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

• IBM Cognos Analytics: Author Reports Fundamentals (v11.0)
• Knowledge of your business requirements
• Knowledge of dimensional data

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