B6061 IBM Cognos Analytics - Author Reports with Multidimensional Data (V11.0)

2 Days

12 CPD hours

Report authors working with dimensional data sources.

Through interactive demonstrations & exercises, participants will learn how to author reports that navigate & manipulate dimensional data structures using the specific dimensional functions & features available in IBM Cognos Analytics.

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 Analytics 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 IBM Cognos Analytics

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

Calculations & Dimensional Functions

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

Functions for Navigating Dimesional 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 & 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