> > > B5A61G Detailed outline

IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.2.2) (B5A61G)

Course Description Schedule Course Outline

Detailed Course Outline

Introduction to Dimensional Concepts

  • Identify different data sources and models
  • Investigate the OLAP dimensional structure
  • Identify dimensional data items and expressions
  • Differentiate the IBM Cognos BI query language from SQL and MDX
  • Differentiate relational and dimensional report authoring styles

 

Introduction to Dimensional Data in Reports

  • Work with members
  • Identify sets and tuples in Report Studio

 

Dimensional Report Context

  • Understand the purpose of report context
  • Understand how data is affected by default and root members

 

Focus Your Dimensional Data

  • Compare dimensional queries to relational queries
  • Explain the importance of filtering dimensional queries
  • Evaluate different filtering techniques
  • Filter based on dimensions and members
  • Filter based on measure values
  • Filter using a slicer
  • Dynamically filter using a tree prompt

 

Calculations and Dimensional Functions

  • Use IBM Cognos BI dimensional functions to create sets and tuples
  • Perform arithmetic operations in OLAP queries
  • Identify coercion errors and rules

 

Functions for Navigating Dimensional Hierarchies

  • Navigate dimensional data using family functions

 

Relative Functions

  • Navigate dimensional data using relative functions
  • Navigate dimensional data using relative time functions

 

Advanced Drilling Techniques and Member Sets

  • Understand default drill-up and drill-down functionality
  • Identify cases when you need to override default drilling behavior
  • Configure advanced drilling behavior to support sophisticated use cases
  • Define member sets to support advanced drilling
  • Define member sets to support functions

 

Set Up Drill-Through Reports

  • Navigate from a specific report to a target report
  • Drill down to greater detail and then navigate to target report
  • Navigate between reports created using different data sources

 

End-to-End Workshop

  • Review concepts covered throughout the course