Presentation Model in IBM Cognos BI
To create the presentation model in the meta-layer of Cognos BI, the Noetix views metadata must be generated into the meta-layer by using Angles for Oracle Generator for IBM Cognos BI (Angles for Oracle Generator). After generating the Noetix views metadata, when users log on to Cognos BI Connection, they can view the presentation model and the data provided in the presentation model.
In the presentation model, the generated global views and the associated key flexfield views are organized into logical groups based on their functional areas. These logical groups are represented as namespaces and are placed within the package created for each NoetixViews module. Within each package, separate namespaces are created for the global views and for the key flexfield views associated with the global views. Apart from the views, these namespaces also contain objects, such as facts and dimensions. The namespaces created for global views within a package are organized based on the Oracle E-Business Suite module or functional area, whichever is applicable, corresponding to the global views. The namespaces created for key flexfield views within a package are organized based on their functional areas and configurations in the global views. This organization of data provides an intuitive way to locate the data you want.
The presentation model in Cognos BI has the following prebuilt and customized namespaces within a package:
<Module/Functional area> Views: Contains all the extracted global views corresponding to a Noetix global role. For example, the name of the namespace created for the ARG0 RECEIVABLES role is “Receivables Views” and the name of the namespace created for the HRG0 HR SALARY MANAGER role is “HR Salary Manager Views.”
All Business Groups KFF Views: Contains the key flexfield views for all business groups. For example, this namespace contains key flexfield views, such as “XXK Grade Grade” and “XXK Position Pos Vac.”
All Charts of Accounts KFF Views: Contains the key flexfield views for all charts of accounts. For example, this namespace contains key flexfield views, such as “XXK GL Acct AcctExp” and “XXK GL Acct AcctDist.”
<Business group name/Legislation name> Business Group KFF Views: Contains the key flexfield views for a business group. For example, the name of the namespace created for the business group Vision Corporation is “Vision Corporation Business Group KFF Views”, and it contains key flexfield views, such as “XXK Grade Grade (Grade Flexfield)” and “XXK Group Peo Grp (People Group Flexfield).”
<Structure name> Chart of Accounts KFF Views: Contains the key flexfield views for a structure. For example, the name of the namespace created for the Operations Accounting Flex is “Operations Accounting Flex Chart of Accounts KFF Views”, and it contains key flexfield views, such as “XXK GL Acct Acct Trx”.
Item Category KFF Views: Contains a key flexfield view for each structure of the Item Categories key flexfield. For example, this namespace contains key flexfield views, such as “XXK Mtl Cat ItemCat (Accounting Category)” and “XXK Mtl Cat ItemCat (Asset Management)”, where Accounting Category and Asset Management are structure names.
Depending on the global views and the key flexfield configuration in the global views, you will see one or more namespaces created in the presentation model.
For information on how global views and the corresponding key flexfield views can be joined in the presentation model of Cognos BI, seePresentation Model in IBM Cognos BI.
The presentation model also provides a reporting solution for the parent-child hierarchies of an Accounting Flexfield segment. The reporting solution consists of two views, parent-child hierarchies and parent-child essentials. These views are configured in the presentation model in the namespace corresponding to each chart of accounts. For example, the “Account Parent-Child Hierarchies” and “Account Parent-Child Essentials” views are configured in the “Operations Accounting Flex Chart of Accounts KFF Views” namespace for the Account segment.
For information about parent-child hierarchy views, see Support for Parent-Child Hierarchies in Global Views in the “NoetixViews for Oracle General Ledger” section in “Module-Specific Information.”
Using Parent-Child Views in IBM Cognos BI
This section discusses two examples for using the parent-child views of an Accounting Flexfield segment hierarchy. The first example discusses how to use the parent-child hierarchies view to build a drill-down report. The second example discusses how to use the parent-child essentials view to build a report that returns all the leaf flex values corresponding to a parent flex value. Also, you can build a drill-through report in Cognos BI by joining the reports created using a parent-child hierarchies view and a parent-child essentials view. For more information about how to create a drill-through report in Cognos BI, see the Cognos BI product documentation.
Example 1
This example discusses how to build a drill-down report using a parent-child hierarchies view and a fact view. The example uses a fact view GL All Balances and a parent-child hierarchies view Account Parent-Child Hierarchies configured in the presentation model for the Operations Accounting Flex chart of accounts. The drill-down report created in the example provides details of the balances for the parent and child flex values of the Account segment. The report is further filtered using a set of books and period.
To build the sample drill-down report using a parent-child hierarchies view
Log on to Cognos BI Connection.
Open Report Studio, and select a package and the reporting layout for the report. In the current example, a package called NoetixViews for Oracle Financials is selected, and a list layout is selected for the report. After you select a package and reporting layout, the package is displayed in the metadata tree of the Reporting Studio.
From the dimension object created for a parent-child hierarchies views, select the parent-child hierarchy drill object that you want to use in your drill-down report, and add it to the report layout. In the current example, a dimension object called Account Parent-Child Hierarchies$DIM is used, and the Description With Value hierarchical drill object is selected from the dimension object and added to the report layout.
From a fact view that you want to use in the report, select the required columns, and add them to the report layout. In the current example, the GLG0 All Balances view is selected, and the Balance,
Set Of Books Name, and Period Name columns from this view are added to the report layout.The final report design after adding all the required columns is displayed on the right pane. In the current example, the sample report design is displayed as follows:
In the screen shot, the display names of the Description With Value, Set Of Books Name, and Period Name columns have been modified as Account Hierarchy, Set Of Books Name, and Period, respectively.
After adding all the required columns to the report layout, specify the filter conditions for the relevant columns. In the current example, a filter condition is set on the Set Of Books Name and the Period Name columns. For the filter condition, the value Vision Operations (USA) is assigned to the
Set Of Books Name column, and the value Apr-01 is assigned to the Period Name column.In the current example, if you want to find hierarchy information of any root flex value that you provided, specify a parameter for the Level01 Description With Value column from the Account Parent-Child Hierarchies view and for the other required columns.
After specifying all the filter conditions, run the report. The report is displayed on the Cognos Viewer. In the current example, the report will display the account balances corresponding to all the root flex values for the Vision Operations (USA) set of books and for the period Apr-01.
To drill-down to the next level in the report, select a root flex value from the hierarchy, and perform a drill-down. In the current example, a drill-down is performed for the Net Income (7999) flex value. The result will display the next level of flex values under the Net Income (7999) flex value. You can drill-down one level at a time up to 20 levels.
Example 2
This example discusses how to build a report using a parent-child essentials view and a fact view. The example uses a fact view GL All Balances and a parent-child essentials view Account Parent-Child Essentials configured in the presentation model for the Operations Accounting Flex chart of accounts. The report created in the example provides details of the account balances corresponding to all the child flex values of a parent flex value for the Account segment. The report is further filtered using a set of books and period.
To build a sample report using a parent-child essentials view
Log on to Cognos BI Connection.
Open Report Studio, and select a package and the reporting layout for the report. In the current example, a package called NoetixViews for Oracle Financials is selected, and a table layout is selected for the report. After you select a package and a reporting layout, the package is displayed in the metadata tree of the Reporting Studio.
From a parent-child essentials view that you want to use in your report, select the required columns, and add them to the report layout. In the current example, a view called Account Parent-Child Essentials view is used, and the Parent Description With Value and Leaf Description With Value columns are selected from this view and added to the report layout.
From a fact view that you want to include in the report, select the required columns, and add them to the report layout. In the current example, the GLG0 All Balances view is selected, and the Balance,
Set Of Books Name, and Period Name columns from this view are added to the report layout.The final report design after adding all the required columns is displayed on the right pane. In the current example, the sample report design is displayed as follows:
In the screen shot, the display names of the Parent Description With Value, Leaf Description With Value, Balance, Set Of Books Name, and Period Name columns have been modified as Parent Description With Value, Leaf Description With Value, Balance, Set Of Books Name, and Period, respectively.
After adding all the required columns to the report layout, specify the filter conditions for the relevant columns. In the current example, a filter condition is set on the Parent Description With Value,
Set Of Books Name, and the Period Name columns. For the filter conditions, the value Net Income (7999) is assigned to the Parent Description With Value column, the value Vision Operations (USA) is assigned to the Set Of Books Name column, and the value Apr-01 is assigned to the Period Name column.In the current example, if you want to use the report to find information about all the child flex values corresponding to any parent value that is provided, specify a parameter for the Parent Description With Value column and for the other required columns.
After specifying all the filter conditions, run the report. The report is displayed on the Cognos Viewer. In the current example, the report will display the account balances corresponding to all the child flex values of the Net Income (7999) parent flex value for the Vision Operations (USA) set of books and for the period Apr-01.