Sunday, January 1, 2012

Cognos 10 FM Creating RMR

Creating a Framework Manager Relational Model - RMR.

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.
Create Joins / relationships between the Query Subjects. Specify the correct Cardinality. From Dimension:Fact --> 1:n

14- Create Model Query Subjects used for Reporting in the Presentation Layer.
Right Click Presentation Layer --> Create Query Subjects.
14a- Select the Columns you want to expose for Reporting; Map it to the database Layer.
15- Give Business Names to the Objects in Presentation Layer.

16- Now, we need to create a Package: Right Click Packages--> Create Package.
17- Hide the Database Layer and check the Presentation Layer.
18- Select a location to publish the package.
19- Verify the model and publish the package.
20- Logon to the Cognos 10 Portal --> Open the package in Report Studio and start creating reports.


No comments:

Post a Comment