IBM Cognos Analytics: Author Reports with Multidimensional Data (v11.0)

Course Outline:

1. Introduction to Dimensional Concepts

• Different data sources and models
• OLAP dimensional structure
• Dimensional data items and expressions
• Differentiate the IBM Cognos Analytics query language from SQL and MDX
• Differentiate relational and dimensional report authoring styles

2. Introduction to Dimensional Data in Reports

• Work with members
• Identify sets and tuples in IBM Cognos Analytics

3. Dimensional Report Context

• Purpose of report context
• How data is affected by default and root members

4. Focus Your Dimensional Data

• Compare dimensional queries to relational queries
• Importance of filtering dimensional queries
• Different filtering techniques
• Filter based on dimensions and members
• Filter based on measure values
• Filter using a slicer

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

6. Functions for Navigating Dimensional Hierarchies

• Navigate dimensional data using family functions

7. Relative Functions

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

8. Advanced Drilling Techniques and Member Sets

• 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

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

10. End-to-End Workshop

• Review concepts covered throughout the course

• Dimensional structures and concepts, data in reports, and report context
• Focus your dimensional data
• Calculations and dimensional functions
• Navigating dimensional hierarchies
• Relative functions
• Advanced drilling techniques
• Drill-through reports
• End-to-end workshop 

While class exercises are performed within a Cognos Analytics v11 environment, our expert instructors can provide guidance on all versions and their differences.

Labs:

Hands-on

This offering is intended for professional report authors who:

• have a knowledge of their business requirements
• basic Windows, and Web functionality

Report authors working with dimensional data sources.