User has successfully saved/updated preferences. Navigate to Dashboard

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

Overview

Contains PDF course guide, as well as a lab environment where students can work through demonstrations and exercises at their own pace.

This course is designed to guide report authors in building on their expertise with IBM Cognos Analytics by applying dimensional techniques to reports. Through interactive demonstrations and exercises, participants will learn how to author reports that navigate and manipulate dimensional data structures using the specific dimensional functions and features available in IBM Cognos Analytics.

Audience

Report authors working with dimensional data sources.

Prerequisites

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

Key topics

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

Objectives

Please refer to course overview

Related Articles:

IBM Training Blog:

Enroll

You can enroll in an instructor-led classroom at different geographic locations, instructor-led online course in any timezone or a self-paced online course.

Delivery Type

Enrollment Results:

City:

Language:

Start date on / after:

Partner:

Guaranteed to Run (GTR):

Start Date My Time Zone GTR Country City Duration Delivery Type Language Partner Action
 16 HoursSelf-paced Virtual CourseEnglishITMS

Enroll



Skip Sign in

 16 HoursSelf-paced Virtual CourseEnglishGlobal Knowledge

Enroll



Skip Sign in

 16 HoursSelf-paced Virtual CourseEnglishLearnQuest

Enroll



Skip Sign in

 16 HoursSelf-paced Virtual CourseEnglishArrow ECS

Enroll



Skip Sign in

 16 HoursSelf-paced Virtual CourseEnglishIngram Micro

Enroll



Skip Sign in

 16 HoursSelf-paced Virtual CourseEnglishTechData Inc.

Enroll



Skip Sign in

Name / Last Name: null
Course code: J4061G
Course title: IBM Cognos Analytics - Author Reports with Multidimensional Data (V11.0) - SPVC

Upon submission of the enrollment request, the status will be pended. The enrollment request will be reviewed by the brand focal. Once approved, you will receive an email with the information and instructions to access the content.

Personal Information Consent for IBM Training and Skills

Business Partner Enrollment Privacy Statement


IBM Training and Skills processes the personal information to operate, maintain and provide you with features and functions that enhance the learning experience. We, at IBM, use aggregated metrics such as number of students, unique visit to site and pattern of usage to improve content and usability as well as progress reports limited to our internal brands to understand consumption of their content, any data contained in these reports is not viewable outside of IBM.


As a business partner, when enrolling in an IBM self-paced virtual classroom course or a web based training course offered at no cost, the brand admin may track your enrolment, completion, and periodically communicate with you about your progress status using the following information:

  • Your Name, Email address, and Company name, CE ID, Country

We will not use your information to send you e-mails:

  • Training and course related notices (including notices from instructor, system related notices about assignments and notifications from course related blogs and wikis).
  • Courses that may be of interest to you.
  • If you open a support ticket with the IBM Training and Skills Helpdesk, then we may contact you via email, we may retain the content of your email messages, your email address and our responses. All Personal information is held for three/3 years (name, email address, completion records), including the content of mail correspondence.

For additional information regarding IBM processing of Personal Information refer to IBM’s Online Privacy Statement:

https://www.ibm.com/privacy/details/us/en/


****FOR EU citizens****


Right to access to the stored data
If you want to request access to your data and make sure that they are accurate and lawfully entered, please send an e-mail to clmshelp@us.ibm.com with the subject line Request Access to the stored data


Right to Data portability
You have the right to receive the personal data concerning you, which you have provided, in a structured, commonly used and machine-readable format and you have the right to transmit those data to another service provider without hindrance.


Data Erasure (Right to be forgotten)
If you want to request erasure of personal data concerning you (i.e. there is no need for processing your personal data), please send an e-mail to clmshelp@us.ibm.com with the subject line Request Data Erasure


Data Rectification
If you want to request rectification in case there are inaccurate personal data (i.e. incomplete personal data). please send an e-mail to clmshelp@us.ibm.com with the subject line Request Data Rectification


Objection to the processing
On grounds relating to your particular situation, at any time the processing of personal data concerning you, including profiling you can object at any time by sending a mail to clmshelp@us.ibm.com with the subject line Request Objection to the processing


Right to lodge a complaint with a supervisory authority
You have the right to lodge a complaint with a supervisory authority, in particular in the EU Member State of your habitual residence, place of work or place of the alleged infringement if you considers that the processing of personal data relating to you infringes the EU GDPR Regulation.

 

Withdrawal of Consent


If you choose to withdraw your consent for this site we will remove all your information. Removal of your information includes removal of access to the site, your training records, scores, and transcripts will be deleted.


Once records are deleted it will not be possible to restore them or provide any training history.


Please click I AGREE to confirm your agreement of the processing purposes noted above, including the sharing of your name, email address, and badge information with Person VUE Acclaim for the purpose of badge administration.