4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

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


Course Description


Overview

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.  

Audience

This intermediate course is for Data Modelers.

Prerequisites

You should have:
  • Knowledge of dimensional modeling and design.
  • Experience using IBM Cognos Connection and Administration.

Key topics

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

Objectives

Please refer to course overview for information.

Course Duration

2 days
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form