Tuesday, September 25, 2012

Advanced Framework Manager Model - Using Scripts

Advanced Framework Manager Model - Using Scripts
Framework Manager Model maintains a log of the activities we do while creating a model.
We can utilise the script to get the change log.
These scripts can also be used for rebuilding the Framework Manager, while debugging model issues.
                 
STEPS:
1- open the Framework Manager Project for RMR.
2- From the Project Menu --> View Transaction History
3- Check the logs.
4- Select only steps till database layer creation. We exclude the presentation Layer steps;
5- Save it as script.
6- Close the project.
7- Create a new blank project.
8- From the Projects --> Run script.
9- Accept the changes.
10- Save the Project....
SO THATS IT...

Cognos 10 Active Reports - Data Toggle Button Bar.

Active Reports - Data Toggle Button Bar.
STEPS:
1- Logon to Cognos 10 Portal.
2- Launch --> Report Studio --> Create Active Report.
3- From the toolbox Drag and Drop Data Toggle Button Bar.
4- Add country.
5- From the toolbox add a list.
6- Drag and Drop Country, Year, Sales Amount, Sales Quantity in the list...
7- Create a New connection.
8- Link Data Toggle Button Bar with the list on Country.
9- Run the report.

SO THATS IT......

Cognos 10 Active Reports - Data Tab Control

Active Reports - Data Tab Control
STEPS:
1- Logon to Cognos 10 Portal.
2- Launch --> Report Studio --> Create Active Report.
3- From the toolbox Drag and Drop Data Tab Control.
4- Add country.
5- From the toolbox add a list.
6- Drag and Drop Country, Year, Sales Amount, Sales Quantity
7- Create a New connection.
8- Link Data Tab Control with the list on Country.
9- Run the report.
SO THATS IT....


Creating Calculations / Filters / Scripts in Framework Manager

Creating Calculations / Filters in Framework Manager
We can create calculations/filters in the framework Manager itself so that it can be used across multiple reports.
Steps:
1- Open the Framework Manager project.
2- Click on the Sales Fact Query Subject.
3- Click Add for Calculations Tab.
4- Create a calcuation - Total Cost = Sales Amount * Quantity.
5- Click Ok.
Filters:
6- There are two types of filters in FM.
a: Standalone filter - Independent filter. Will be applied when its explicitly part of the report.
b: Embedded filter - Part of a query Subject. Is applied automatically when any query item is used from that Query Subject.

Embedded filter
7- Double click Customer Dimension.
8- Click on Filter Tab.
9- Create an Embedded filter - Country in USA, IN
10- Click Ok and close.
Standalone Filter
11- Right Click the Presentation Layer and create a filter.
12- Country in USA
Converting Embedded Filter to Standalone Filter:
13- Double click Customer Dimension.
14- Click on Filter Tab.
15- Convert filter to Standalone.
16- Re-publish the Package.
17- Create the report and use the calcualtions and filters.
SO THATS IT......

Framework Manager Dimensional Model - DMR

Creating a Framework Manager Dimensional Model - DMR.
Dimensional Model enables Drill Up and Drill Down functionality, Where we can traverse through the Hierarchy.
The Steps from #1 to 13 are similar to Framework Manager Relational Model - RMR.
We will use the Project created using the Scripts as shown in  Advanced FM- Using Scripts.

SO for this please refer videos:
a- Framework Manager Relational Model - RMR
b- Advanced Framework Manager Model - Using Scripts
STEPS: 
1- Open the Framework Manager.
2- Click on New Project. Give a name.
3- Please notice that a Folder same as Project Name is automatically. The project file has an extension .cpf --> Cognos Project File.
4- Select the Language for FM --> English.
5- Select the type datasource.
6- Select a datasource --> DB from where you get the data for your reports.
7- Select the tables / views which are required for reporting.
8- Uncheck the options for identifying joins from DB.
9- Import the tables/views, Known as Query Subject in Cognos world.
10- Identify the usage property for each Columns (Query Items).
Identifier --> Ids/ Codes / Dates  
Fact --> Number / Figures / Measures
Attribute --> Remaining Query Items :-)
11- Right click on the project, create 2 Namespaces:
Database Layer
Presentation Layer.
12- Drag and Drop all the Query Subjects in the database Layer.
13- Create Joins between the Query Subjects. Specify the correct Cardinality. From Dimension:Fact --> 1:n
NOW, we will use the TestProject that we created using FM-Scripts:
14- Create Regular Dimension & Measure Dimension the Presentation Layer.
15- Right click Presentation Layer
--> Create Regular Dimension.
--> Create a Hierarchy
--> Create 4 Levels - Year/Quarter/Month/Date
--> From the Database Layer, associate the query items to the different levels.
16- Similarly create Regular Dimensions for Customer Geography --> Country/City/Customer
17- Create Measure Dimension add Sales Amount and Sales Quantity.
18- Create a Package: Right Click Packages--> Create Package.
19- Hide the Database Layer and check the Presentation Layer.
20- Select a location to publish the package.
21- Verify the model and publish the package.
22- Logon to the Cognos 10 Portal --> Open the package in Report Studio and start creating reports.
23- Drag and Drop Level Country, Level Year along with Sales Amount / Sales Quantity.
24- From the data menu, Drill Behaviour enable Drillup-DrillDown
25- Run the report.
SO THATS IT.......