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

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

Work with members

Identify sets and tuples in IBM Cognos Analytics

Understand the purpose of report context

Understand how data is affected by default and root members

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

Use IBM Cognos Analytics dimensional functions to create sets and tuples

Perform arithmetic operations in OLAP queries

Identify coercion errors and rules

Navigate dimensional data using family functions

Navigate dimensional data using relative functions

Navigate dimensional data using relative time functions

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

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

Review concepts covered throughout the course