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

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

Introduction to IBM Cognos Dynamic Cubes

• Overview of Dynamic Cubes
• Identify the challenges of large data volumes that are resolved by dynamic cubes
• Examine dynamic cube characteristics and requirements
• Explore the related components, tools, and high-level architecture
• Describe the dynamic cube lifecycle, from business requirements to application
• Examine how dynamic cubes use caching

Create and Design a Dynamic Cube

• Explore the IBM Cognos Cube Designer interface
• Review the automatic and manual processes to create a cube
• Extend the metadata in an existing cube

Deploy and Configure a Dynamic Cube

• Deploy and publish a dynamic cube
• Configuration and management of a published cube
• Examine query service administrative tasks
• Explore dynamic cube properties
• Configure a dynamic cube to trigger a report

Advanced Dynamic Cube Modeling

• Identify advanced modeling techniques and caveats
• Examine calculated members and measures
• Model a relative time dimension
• Explore multi-lingual support
• Define parent-child dimensions in dynamic cubes

Optimize Performance with Aggregates

• Examine aggregation in dynamic cubes
• Identify types of aggregates (database and in-memory)
• Allocate memory for cache and aggregates
• Explore the aggregate workflow
• Explore Aggregate Advisor
• Use an aggregate slicer to properly route data

Define Security

• Overview of dynamic cube security
• Identify existing roles and capability requirements
• 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
• Apply security to virtual cubes
• Publish a virtual cube