Font size:

This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Analytics 11 �Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.



Prerequisites:
  • Knowledge of dimensional modeling and design
  • Experience using the IBM Cognos Analytics portal and Administration


Audience:

Data modelers


Course Outline:

1. Introduction to IBM Cognos Dynamic Cubes

  • Differentiate Dynamic Cubes
  • Dynamic Cubes Characteristics
  • Dynamic Cube Requirements
  • Dynamic Cube Components
  • High Level Architecture
  • IBM Cognos Dynamic Query
  • Dimensional Data Structures
  • Dynamic Cubes Caching

2. Create and Design a Dynamic Cube

  • IBM Cognos Cube Designer
  • Cube Development Process
  • the Automatic Cube Generation
  • Manual Development Overview
  • Create Dimensions
  • Model the Cube
  • Best Practice for Effective Modeling

3. Deploy and Configure a Dynamic Cube

  • Deploy a Cube
  • Estimate Hardware Requirements
  • Cube Management Tasks
  • Query Service Administration
  • Dynamic Cube Properties
  • Schedule Cube Actions
  • Use the DCAdmin Comment Line Tool

4. Advanced Dynamic Cube Modeling

  • Advanced Modeling Concepts
  • Modeling Caveats
  • Calculated Measures and Members
  • Model Relative Time
  • Explore the Current Period Property
  • Period Aggregation Rules for Measures

5. Advanced Features of Cube Designer

  • Multilingual Support
  • Ragged Hierarchies and Padding Members
  • Parent-Child Dimensions
  • Refresh Metadata
  • Import Framework Manager packages
    Filter Measures and Dimensions

6. Optimize Performance with Aggregates

  • Aggregates and Aggregate Tables
  • In-memory Aggregates
  • Use Aggregate Advisor to Identify Aggregates
  • User Defined in-Memory Aggregates
  • Optimize In-Memory Aggregates Automatically
  • Aggregate Advisor Recommendations
  • Monitor Dynamic Cube Performance
  • Model Aggregates (Automatically vs. Manually)
  • Use Slicers to Define Aggregation Partitions

7. Define Security

  • Overview of Dynamic Cube Security
  • Identify Security Filters
  • The Security Process
  • Security Scope
  • Scope Rules
  • Roles
  • Capabilities and Access Permissions
  • Cube Security Deep Dive

8. Model a Virtual Cube

  • Explore Virtual� Cubes
  • Create the Virtual Cube
  • Explore Virtual Cube Objects
  • Examine Virtual Measures and Calculated Members
  • Currency Conversion Using Virtual Cubes
  • Security on Virtual Cubes

9. Introduction to IBM Cognos Analytics

  • IBM Cognos Analytics
  • Redefined Business Intelligence
  • Self-Service
  • Navigate to Content in IBM Cognos Analytics
  • Interact with the User Interface
  • Model Data with IBM Cognos Analytics
  • IBM Cognos Analytics Components
  • Create Reports
  • Perform Self-Service with Analysis and Dashboards
  • IBM Cognos Analytics Architecture (High Level)
  • IBM Cognos Analytics Security
  • Package / Data Source Relationship
  • Create Data Modules
  • Upload Files
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live1/25/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1595.002458640
Virtual Live3/28/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1595.002458644
Virtual Live4/12/2018 11:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1595.002458639
Virtual Live5/24/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>2 days1595.002458643
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items