• Select a country/region: United States
  • IBM®
  • Site map

  • Training - worldwide
  • Training
  • Course catalog

Course description: IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.1)

  • Add course to my custom catalog
  • Add to my training plan

Interested in bringing a class to you? Onsite training

Overview

  • Special note
  • Audience
  • Prerequisites
  • Skills taught
  • Course outline
List of course details in a data table
Course code B5161 Skill level Advanced
Duration 2.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $1,400.00 plus tax    

IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.1) is an advanced two-day, instructor-led course in which professional report authors build on their experience with Report Studio by applying dimensional techniques to reports. Through interactive demos and workshops, students will learn how to author reports that navigate and manipulate dimensional data structures using specific dimensional functions and features available in Report Studio.

View this course in other countries


Training Paths that reference this course are:

  • IBM Cognos BI 8.4 – Professional Author Role
  • IBM Cognos BI 10.1 – Professional Author Role

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - Online Account

Back to top

Audience

This advanced course is intended for Professional Report Authors working with dimensional data sources.

Back to top

Prerequisites

You should attend the IBM Cognos Report Studio: Author Professional Reports Fundamentals (V10.1) course and have:

  • Knowledge of your business requirements
  • Experience using Advanced Windows and Web functionality

Back to top

Skills taught

Please refer to course overview for description information.

Back to top

Course outline

Introduction to Dimensional Concepts

  • Discuss dimensional structure and benefits
  • Compare dimensional and relational model types
  • Examine dimensional data structure

Introduction to Dimensional Data in Reports

  • Define and use members in reports
  • Define and use sets in reports
  • Define tuples and data intersections
  • Examine dimensional functions for members, sets, and tuples
  • Explore user interface methods for adding data to reports

Dimensional Report Context

  • Examine the impact of report context
  • Understand current members, root members and default members
  • Understand current measures and default measures

Focus Your Dimensional Data

  • Compare relational and dimensional queries
  • Identify dimensional style filtering techniques
  • Filter non-null data
  • Focus reports based on members
  • Focus reports based on measures

Calculations and Dimensional Functions

  • Create totals and aggregates
  • Combine functions for complex calculations
  • Avoid common errors

Functions for Navigating Dimensional Hierarchies