Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

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

IBM Course Code: B5A63G

GK# 2901 Vendor# B5A63G

$720 - $1595 CAD

Enroll Request Group Training
JUMP TO:

Course Overview

TOP

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.

Outline

TOP
Viewing outline for:

Classroom Live Outline

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

Who Should Attend

TOP

This intermediate course is for Data Modelers.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 2 day

Self-Paced

On-demand content enables you to train on your own schedule.



Request this course in a different delivery format.
Enroll