Omit Categories Using Apex ............................138
Setting Up Drill-through Targets ............................139
Drill Through in IBM Cognos BI ...........................139
Drill Through in IBM Cognos Series 7 .........................140
Use Alternate Data Sources for Cube Creation .......................143
Build a Subset of Your Cube Data for Testing Purposes ....................143
Update the PowerCube Metadata............................144
Check Cube Status ................................144
Chapter 7. Adding Security ..........................147
PowerCubes with IBM Cognos Series 7 Security ......................147
Choosing the Type of Security to be Applied ........................147
IBM Cognos Security Objects .............................148
Create Member-based Security ............................149
Update Model Security ..............................151
Union of Custom Views ...............................151
Example - Two Custom Views, Each with an Apex in the Same Dimension.............152
Example - Apexed Custom View Cloaked by Another Custom View in the Same Dimension .......153
Example - Apexed Custom View Excluded by Another Custom View in the Same Dimension ......153
Example - Union of Two Apexed Custom Views in Different Dimensions .............154
Example - Union of Two Multi-dimensional Apexed Custom Views ...............154
Example - Union of Excluded Categories in Two Dimensions .................155
Examples - Unions of Excluded Categories in the Same Dimension ...............155
Example - Union of Excluded and Cloaked Categories in the Same Dimension ...........156
Example - Union of a Custom Views with Omitted Dimensions ................156
Create Password-protected Cubes ...........................157
Combining Custom Views with Dimension Views ......................157
Block Total Values for Parent Categories with Excluded Children .................158
Upgrade an IBM Cognos Series 7 Secured PowerCube ....................158
Chapter 8. PowerCubes in Production Environments ...............161
Managing Languages and Locales ...........................161
Publishing PowerCubes ...............................162
Publishing a PowerCube Using the Wizard .......................163
Publishing a PowerCube Using Settings Stored in the Model .................165
Creating a Publish Specification to Publish One PowerCube ..................166
Creating a Publish Specification to Publish All PowerCubes in the Model .............167
Publishing a Cube Group .............................168
PowerCube Load Balancing .............................168
Maintaining Models and Cubes ............................169
Source Data Updates ...............................169
Model Updates .................................169
Cube Updates .................................170
Automatic Creation of Multifile Cubes .........................170
Recovering a Failed Model .............................171
Matching Model and Source Columns .........................172
Move Categories When Source Data Changes ......................173
Cleaning up Your Models and Cubes .........................174
Modifying a PowerCube..............................179
Update Cubes Incrementally ............................179
Choosing a Partitioning Strategy ...........................180
Updating Published PowerCubes and PowerCube Connections..................186
Copying and Activating a Newer Version of a Published PowerCube...............187
Activating a Published PowerCube Using pcactivate ....................189
Chapter 9. Guidelines for Optimizing Production Environments ...........191
Building PowerCubes in UNIX or Linux .........................191
Guidelines for Model Design, Cube Creation, and System Maintenance Process ...........192
Setting Up Data Sources for UNIX and Linux Cubes ....................192
Using IBM Cognos Reports to Create a Data Source ....................193
vi IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General