IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)

Course Outline

1: Introduction to IBM Cognos Dynamic Cubes
- Define and differentiate Dynamic Cubes
- Dynamic Cubes characteristics
- Examine Dynamic Cube requirements
- Examine Dynamic Cube components
- Examine high level architecture
- IBM Cognos Dynamic Query
- Review Dimensional Data Structures
- Dynamic Cubes caching

2: Create and design a Dynamic Cube
- Explore the IBM Cognos Cube Designer
- Review the cube development process
- Examine the Automatic Cube Generation
- Manual development overview
- Create dimensions
- Model the cube
- Best practice for effective modeling

3: Deploy and configure a Dynamic Cube
- Deploy a cube
- Explore the Estimate Hardware Requirements
- Identify cube management tasks
- Examine Query Service administration
- Explore Dynamic Cube properties
- Schedule cube actions
- Use the DCAdmin comment line tool

4: Advanced Dynamic Cube modeling
- Examine advanced modeling concepts
- Explore modeling caveats
- Calculated measures and members
- Model Relative Time
- Explore the Current Period property
- Define period aggregation rules for measures

5:Advanced features of Cube Designer
- Examine multilingual support
- Examine ragged hierarchies and padding members
- Define Parent-Child Dimensions
- Refresh Metadata
- Import Framework Manager packages
- Filter measures and dimensions
 
6: Optimize performance with aggregates
- Identify aggregates and aggregate tables
- In-memory aggregates
- Use Aggregate Advisor to identify aggregates
- User defined in-memory aggregates
- Optimize In-Memory Aggregates automatically
- Aggregate Advisor recommendations
- Monitor Dynamic Cube performance
- Model aggregates (automatically vs manually)
- Use Slicers to define aggregation partitions

7: Define Security
- Overview of Dynamic Cube security
- Identify security filters
- The Security process - Three steps
- Examine security scope
- Identify scope rules
- Identify roles
- Capabilities and access permissions
- Cube security deep dive

8: Model a virtual cube
- Explore virtual  cubes
- Create the virtual cube
- Explore virtual cube objects
- Examine virtual measures and calculated members
- Currency conversion using virtual cubes
- Security on virtual cubes

A: Introduction to IBM Cognos Analytics (Optional)
- Define IBM Cognos Analytics
- Redefined Business Intelligence
- Self-service
- Navigate to content in IBM Cognos Analytics
- Interact with the user interface
- Model data with IBM Cognos Analytics
- IBM Cognos Analytics components
- Create reports
- Perform self-service with analysis and Dashboards
- IBM Cognos Analytics architecture (high level)
- IBM Cognos Analytics security
- Package / data source relationship
- Create Data modules
- Upload files