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.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Please refer to course overview

1

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

  • Introduction to Dimensional Data in Reports

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

  • Dimensional Report Context

  • Understand the purpose of report context
    Understand how data is affected by default and root members
4

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

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

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

Audience

Report authors working with dimensional data sources will benefit from this course.

Language

English

Prerequisites

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

$1,550

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
11
Jul
Tuesday
9:00 AM ET -
5:00 PM ET
Almost Full
5 seat(s) left
Schedule select
07
Sep
Thursday
9:00 AM ET -
5:00 PM ET
Almost Full
5 seat(s) left
Loading...