Example 2
by Christopher Yao, Carlos Ruiz, Steven Rogers, Chris McPherson, Skyla Loomis, Beth
IBM Cognos Dynamic Cubes
- Notices
- Preface
- Chapter 1: Overview of Cognos Dynamic Cubes
- Chapter 2: IBM Cognos Dynamic Cubes architecture
- Chapter 3: Installation and configuration of Cognos Cube Designer and Dynamic Query Analyzer
- Chapter 4: Modeling dynamic cubes
- Introduction to IBM Cognos Cube Designer
- Working with Cognos Cube Designer
- Modeling dimensions
- Calculated members
- Modeling time dimensions for relative time
- Slowly changing dimensions
- Role-playing dimensions
- Multi-grain fact scenarios
- Aggregate cubes
- Validation
- Deploying dynamic cubes for reporting and analysis
- Troubleshooting
- Creating a sample cube model by using GOSLDW
- Creating a time dimension
- Modeling for multi-grain scenarios
- Chapter 5: Administering dynamic cubes
- Chapter 6: Virtual cubes
- Chapter 7: Dimensional security
- Overview of dimensional security
- Security model
- Grant versus deny approaches to security
- Visible ancestors
- Secured padding members
- Default members
- Calculated members
- Merging of security views or security filters
- Defining security in Cognos Cube Designer
- Publish and start the cube
- Applying security views
- Verifying the security model
- Chapter 8: Optimization and performance tuning
- Performance implications of OLAP-style reports
- Aggregate awareness in Cognos Dynamic Cubes
- Overview of the Aggregate Advisor
- Model-based analysis
- Workload-based analysis
- Running the Aggregate Advisor without considering workload information (1/2)
- Running the Aggregate Advisor without considering workload information (2/2)
- Running the Aggregate Advisor with considering workload information
- Opening Aggregate Advisor results and viewing details (1/2)
- Opening Aggregate Advisor results and viewing details (2/2)
- Rerunning the Aggregate Advisor
- In-memory aggregates
- Database aggregates
- Cache Priming Techniques
- Cache size best practices
- Scenarios for performance tuning
- Chapter 9: Dynamic cube lifecycle
- Overview of the dynamic cube lifecycle
- Lifecycle across different environments
- Best practices for deploying between environments
- Keep a copy of the dynamic cube project file under source control
- Use consistent data source, schema, and table names in all environments
- Skip the optimize step in the development environment
- Use a separate database for each environment
- Include complete dimensional data in development environment
- Make the test system similar to the production system
- Chapter 10: Troubleshooting
- Related publications
- Back cover
168 IBM Cognos Dynamic Cubes
7.8.3 Example 2
Similar to Example 1, the security view 2 has access to all but Boston and Calgary. However,
because security view 2 was defined by using the Grant All Members filter, granting all
members has the same weight as granting rules in security view 1.
Security view 1
Figure 7-39 shows granting Canada, Mexico, Brazil, and descendants.
Figure 7-39 Security view 1: Grant Canada, Mexico, Brazil, and descendants
170 IBM Cognos Dynamic Cubes
Figure 7-41 shows the consolidated view for a user who is assigned to both the views.
Figure 7-41 Consolidated view for a user assigned to both views
The default member continues to be All because it was granted in security view 2. All and
Americas are not visible ancestors because they were granted in security view 2.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.