The IBM Cognos Framework Manager product allows you to create dimensionally modeled relational (DMR) models. A DMR refers to the dimensional information that a modeler supplies for a relational data source to allow for OLAP-style queries, which allow for navigational functionality and access to dimensional functions in studios that support dimensional functions, such as IBM Cognos Report Studio and IBM Cognos Business Insight Advanced.
Dimensional information is defined through the following dimensions:
A dimensionally modeled layer can be applied to any metadata in star schema format. When your metadata is in star schema format, you can provide hierarchy information to dimensions and measure scope for each Regular Dimension created.
Create Regular Dimensions
Regular Dimensions consist of one or more user-defined hierarchies. Each hierarchy consists of the following components:
Level information is used to roll up measures accurately when performing queries or analyses. Regular Dimensions require that each level have a key and caption specified, and that the caption be a string data type. These items are used to generate members in the studios data trees (where applicable) and retrieve the members at run time.
The following steps show one example of how to create a Regular Dimension. In this case, we model a Time dimension.
Dimension Definition dialog box
You need to assign a business key and member caption to each level. Remember, a caption must be a string data type. In this case Year is an integer; therefore, you need to create an item to cast Year into a string.
Specify Roles dialog box for Regular Dimension
Year level roles
Unique Level check box
The Unique Level check box indicates that the keys in the levels above the current level are not necessary to identify the members in a level. If they are, then leave this check box clear. The top level does not need this setting, because it has no parent keys.
Notice that the _businessKey role is already assigned to Day Key in the bottom pane, because Day Key is an identifier as it is the primary key in the underlying table.
Time dimension hierarchy completed
For some dimensions, such as the Time dimension, ensure specific sorting of the data in all scenarios to take advantage of dimensional functions that navigate the data. For example, you might want to use the Lag function, which allows you to view the current month and the previous month by lagging one month from the current month in a calculation. For these types of functions to work, the order of the data must be correct and consistent. If your business keys, captions, or attributes are sortable so that there is a logical order to the data, you can use the Member Sort feature for Regular Dimensions to ensure the correct structure for you data.
Dimension Definition, Member Sort tab
Dimension Definition, Member Sort tab
For more information about the Member Sort feature, refer to the IBM Cognos Framework Manager User Guide.
New Regular Dimension for Time
The new Time dimension is now complete and when expanded in the Project Viewer displays.
Time dimension expanded in Project Viewer
Again, if you are feeling adventurous, create a dimension for Products and Order Method We include the results in the model that we provide with this book.
Products dimension configuration
Order Methods dimension configuration
Create Measure Dimensions
A Measure Dimension is a logical collection of facts that enables OLAP-style analytical querying and is related to Regular Dimensions within scope.
To create Measure Dimensions:
Sales Measure Dimension
Sales Fact and Sales Target Fact Measure Dimensions expanded in the Project Viewer
Define scope for measures
Measure Dimensions are related to Regular Dimensions through scope relationships that define at what levels a measure is in scope. However,underlying join relationships are still required to generate the SQL that is sent tothe data source.
A scope relationship is created automatically between a dimension and a measure dimension whose underlying query subjects have a valid JOIN relationship defined and are required to achieve predictable roll ups.
To define the scope of a measure or group of measures, you can use the Dimension Map in the Project Info pane. To define the scope for the Sales Fact and Sales Target Fact MeasureDimensions:
You can double-click the relationships to edit scope. However, in our example, we use the Dimension Map because it is a central location to define scope easily for all measures. You can also create, edit, and delete Regular Dimensions and Measure Dimensions in this pane.
Sales Fact scope
All levels in all dimensions are highlighted indicating that they are all currently in scope, which is correct for the Sales Fact measures. However, this is not the case for Sales Target Fact, which is at the Month level for the Time dimension and Product Type level for the Products dimension. Sales Fact is also not in scope at all for the Order Methods dimensions. We set the appropriate scope for the Sales Target measure.
Set Scope toolbar icon
The Day level for the Time dimension and the Product Name level for the Products dimension are no longer highlighted and are out of scope for Sales Target Fact. The Order Methods dimension is completely out of scope.
Scope settings for Sales Target Fact
These namespaces are used to organize the relational and dimensional presentation views.
Presentation View organized
Next, create star schema groupings for the DMR objects and place them in the Analysis namespace.
Create Star Schema Grouping dialog box
The Measure Dimension and all related Regular Dimensions are selected automatically based on the scope relationships.
Final Presentation view
IBM Cognos Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|IBM DB2 Interview Questions||Data Warehousing Interview Questions|
|SQL Interview Questions||IBM Cloud Computing Infrastructure Architect V1 Interview Questions|
|Framework7 Interview Questions||IBM BPM Interview Questions|
|IBM Cognos TM1 Interview Questions||Cognos ReportNet (CRN) Interview Questions|
|Structured Query Report (SQR) Interview Questions||IBM DataPower Interview Questions|
Ibm Cognos Tutorial
Introduction To Ibm Cognos Business Intelligence
Overview Of The Ibm Cognos Business Intelligence Architecture
Business Scenario And Personas Used In This
Create Reporting Packages With Ibm Cognos Framework Manager
Business Intelligence Simplified: An Overview
Individual And Collaborative User Experience
Self Service Interface For Business Users
Actionable Analytics Everywhere
Enterprise Ready Performance And Scalability
Ibm Cognos System Administration
Integrating Ibm Cognos Bi With Ibm Cognos Business Analytics Solutions
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.