Example: Combination of visible and granted ancestors
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
152 IBM Cognos Dynamic Cubes
Security view 2: Grant United States and descendants
Figure 7-4 shows granted United States and descendants.
Figure 7-4 Granted United States and descendants (1)
Figure 7-5 shows the result.
Figure 7-5 Granted United States and descendants (2)
United States and descendants are granted, so they will have value. The All member and
Americas are visible ancestors so have their values secured, as the simple report shows
(Figure 7-6).The values for any tuple that contains All or Americas will be secured, as the
figure shows.
Figure 7-6 Report values for any tuple containing All or Americas
7.4.3 Example: Combination of visible and granted ancestors
Security view 3 illustrates the possibility of having a combination of granted and visible
ancestors in a path to the hierarchy.
Security view 3: Grant Miami and descendants, grant Americas
Figure 7-7 on page 153 shows the granted Miami and descendants and the Americas, for
example:
? Grant Miami and descendants
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.