Loading...

B5A63G – IBM Cognos Cube Designer: Design Dynamic Cubes

Home / B5A63G – IBM Cognos Cube Designer: Design Dynamic Cubes

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 analyze results using IBM Cognos Cube Designer. Students 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.

Course Length: 2 day(s)

Course Price: $1400 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom

Enroll Now

Course: B5A63G – IBM Cognos Cube Designer: Design Dynamic Cubes

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

Audience 

This intermediate course is for Data Modelers.

Prerequisites 

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

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.