Track Changes in a Measure in Future Time Periods .....................84
Track Monthly Performance Measures in Different Time Periods.................85
Setting up Special Categories .............................85
Create a New Special Category ............................85
Create Special Category Levels ............................86
Disable Rollup on Special Categories ..........................87
Resolving the Parentage of Orphan Categories........................88
Resolve Invalid Date Errors ..............................88
Adjust the Date Range to Encompass Early and Late Dates ...................89
Set up a Manual Level for Unknown Categories .......................89
Prevent New Categories from Being Added to a Dimension ...................90
Verifying Your Model ................................90
Generating Categories from a Specified Data Source .....................91
Chapter 5. Modeling Your Key Performance Measures ...............93
Add a Regular Measure ...............................94
Define a Measure Folder ...............................95
Define a Measure that Counts Categories .........................95
Define a Calculated Measure .............................97
Define When Measures are Calculated ..........................97
Specify How Missing Values Appear ...........................98
Reverse the Sign of Measure Values in Financial Models ....................99
Cognos Transformer Functions .............................99
Controlling How Measures Roll Up ...........................100
Set a Regular Rollup Function for Measures .......................101
Create Cubes with External Rollups ..........................102
Set a Time State Rollup Function for Measures ......................103
Ignore Null and Missing Values in Specified Time State Rollups ................105
Set Regular and Time State Rollup Together .......................106
Consolidation ..................................107
Example - Consolidating Data Using Duplicates Rollup (Sum) .................107
Set a Duplicates Rollup Function for Measures ......................108
Allocating Measures ................................109
Show the Scope for a Measure............................110
Set Dimension Allocation .............................111
Set Level Allocation ...............................112
Set Category Allocation ..............................113
Suppress Allocation ...............................114
Setting Up Currency Conversion ............................115
Enabling Conversion Using a Base Currency Table .....................116
Enable Conversion Using a Euro Table .........................118
Update a Currency Table Manually ..........................121
Chapter 6. Creating PowerCubes ........................123
Create a Single PowerCube..............................123
Create a Cube Group ................................125
Defining a Time-based Partitioned Cube .........................125
Advantages of a Time-based Partitioned Cube ......................126
Disadvantages of a Time-based Partitioned Cube .....................126
Create a Time-based Partitioned Cube Group.......................128
Processing Issues Related to Time-based Partitioned Cubes ..................128
Customizing a Time-based Partitioned Cube .......................131
Exclude Measures from a Cube ............................131
Omit Dimensions from a Cube ............................132
Customizing Cube Content with Views..........................132
Create a Dimension View .............................133
Omit Categories Using Suppress ...........................134
Omit Categories Using Cloak ............................135
Omit Categories Using Exclude ...........................136
Omit Descendant Categories Using Summarize ......................137
Contents v
To Next Page
Loading...
Need help?
General