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

IBM Cognos Cube Designer: Design Dynamic Cubes (V10.2) is a two-day, instructor-led course that is designed to provide 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.

View this course in other countries

Til top

This intermediate course is intended for Data Modelers and Administrators who design dynamic cubes that are used to develop applications in the IBM Cognos environment.

Til top

You should have:

• Knowledge of common industry standard data structures and design, and experience gathering requirements and analyzing data.

Til top

Please refer to the Course Overview for description information.

Til top

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

Til top