Chapter 9: Dynamic cube lifecycle
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
© Copyright IBM Corp. 2012. All rights reserved. 245
Chapter 9. Dynamic cube lifecycle
This chapter describes the five main stages in the dynamic cube lifecycle and how they fit
within a three-tiered approach of moving from development to test to production. This chapter
also offers best practice approaches for moving a dynamic cube onto separate systems.
This chapter contains the following sections:
? 9.1, “Overview of the dynamic cube lifecycle” on page 246
? 9.2, “Lifecycle across different environments” on page 247
? 9.3, “Best practices for deploying between environments” on page 253
9
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.