IBM Cognos Cube Designer: Design Dynamic Cubes (V10.2.2) provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing dynamic cubes, and enabling end users to easily author reports and analyze data.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

Please refer to course overview.

This intermediate-level course is for Data Modelers.

You should have:

• Knowledge of dimensional modeling and design.
• Experience using IBM Cognos Connection and Administration.

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

A: 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