> > > 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