IBM Cognos Cube Designer: Design Dynamic Cubes (V10.2.2)

Introduction to IBM Cognos Dynamic Cubes

• Define and Differentiate Dynamic Cubes
• Identify the Challenges of Very Large Data and how Dynamic Cubes resolves those issues
• Examine dynamic cube characteristics
• Examine dynamic cube requirements
• Examine high-level architecture
• IBM Cognos Dynamic Query
• Review Dimensional Data Structures
• Describe the dynamic cube process flow and lifecycle
• Examine how dynamic cubes use caching

Create and Design a Dynamic Cube

• Explore the IBM Cognos Cube Designer
• Review the cube development process
• Examine the automatic cube generator
• The Manual Development Process
• Examine Modeling Strategies

Deploy and Configure a Dynamic Cube

• Deploy and publish a dynamic cube
• Use the Hardware Sizing Wizard
• Configuration and management of a published cube
• Assign an Access Account
• Examine query service administration tasks
• Explore dynamic cube properties
• Configure a dynamic cube to trigger a report
• Run Administrative Commands with the DCAdmin Command Line Tool

Advanced Dynamic Cube Modeling

• Identify advanced modeling techniques and caveats
• Examine calculated members and measures
• Model a relative time dimension
• Explore Custom Relative Time
• Explore the Current Period Property
• Define Period Aggregation Rules for Measures
• Create and Use Named Sets
• Examine the Shared Dimension Property

Advanced Features of Cube Designer

• Examine Multilingual Support
• Define Parent-Child Dimensions (ragged hierarchies)
• Refresh Metadata in an Existing Cube
• Import Framework Manager packages into Cube Designer
• Filter measures and dimensions

Optimize Performance with Aggregates

• Examine aggregation in dynamic cubes
• Identify types of aggregates (database and in-memory)
• Examine user-defined, in-memory aggregates
• Use Aggregate Advisor to identify aggregates
• Use Automatic In-Memory Aggregate Optimization
• Allocate memory for cache and aggregates
• Explore the aggregate workflow
• Explore the aggregate advisor
• Use Slicers

Define Security

• Overview of dynamic cube security
• Types of Security
• Examine Security Scope
• Identify roles and capability requirements
• Define Security Using Relational Database Tables
• Use security filters to define hierarchy security views
• Assign users and groups to security views

Model a Virtual Cube

• Examine the benefits, requirements, and build process of virtual cubes
• Explore virtual cube objects: dimensions and hierarchies
• Examine virtual levels in merged hierarchies
• Explore Currency Conversion Using a Virtual Cube
• Apply security to virtual cubes
• Publish a virtual cube

Overview of IBM Cognos BI

• Describe the IBM Cognos Family
• Identify the positioning of each component and studio in IBM Cognos BI
• Examine the high level IBM Cognos BI architecture
• Describe Cognos BI groups and roles