IBM Cognos BI Report Studio Cube Sourced Reporting

Course Length: 2 Days  |  Price: $995  |  Please contact us today to schedule your training

< Education Services page

IBM Cognos BI Report Studio Cube Sourced Reporting is an advanced two day instructor led or instructor led online course. It replaces the IBM Cognos BI Multidimensional Reporting offering and is designed to provide you an opportunity to build on your experience with Report Studio by applying dimensional data source techniques to your reports.

This course is designed for existing users of IBM Cognos Report Studio. This course will acquaint participants with traditional cube sources used for dimensional source reporting, as well as introducing participants to TM1 cubes as a dimensional source for reporting.

Using a combination of lectures, instructor led demos and workshops in a high-quality learning environment, participants will learn how to author reports that navigate and manipulate dimensional data sources using specific functions and features available in Report Studio.

Intended Audience

This advanced course is for professional authors, administrators, and modelers with applied knowledge of Report Studio with relational database sources needing to learn the functionality and features of IBM Report Studio with dimensional data sources.

Prerequisites

  • Knowledge of your business requirements
  • Experience using IBM Cognos Report Studio

Request a Course

[[[["field19","contains","@gmail"],["field19","contains","@googlemail"],["field19","contains","@outlook"],["field19","contains","@yahoo"],["field19","contains","@aol"],["field19","contains","@aim"],["field19","contains","@yandex"],["field19","contains","@inbox"],["field19","contains","@protonmail"],["field19","contains","@zoho"],["field19","contains","@icloud"],["field19","contains","@mail"],["field19","contains","@gmx"],["field19","contains","@fastmail"],["field19","contains","@hush"],["field19","contains","@hotmail"]],[["hide_fields","field11"],["show_fields","field17"]],"or"]]
1
First Name
Last Name
Title
Company
Phone
Please provide a valid email address from your business or organization. Thank you.
Requested Date
Previous
Next
  • Identify different data sources and models
  • Investigate the OLAP dimensional structure
  • Identify dimensional data items and expressions
  • Compare the IBM Cognos BI query language to SQL and MDX
  • List the components of a member
  • Define Member Unique Name (MUN)
  • Identify what changes will impact a MUN
  • Work with members and their children
  • Identify sets and tuples in Report Studio
  • Explain the concept of report context
  • Describe the difference between the default and root members
  • Distinguish between the default measure and the current measure
  • Explain the difference between relational report query results and cube sourced report results
  • Describe the importance of filtering a cube sourced report
  • Filter based on dimensions, members, and measures
  • Use a slicer filter
  • Create a tree prompt filter in a report
  • Use dimensional functions to control members returned in a crosstab report
  • Discuss the difference between the total and aggregate functions
  • Create simple arithmetic expressions
  • Recognize a coercion error and describe its purpose
  • Use family functions to navigate dimensional hierarchies
  • Use relative functions to navigate dimensional structures
  • Use relative time functions to navigate dimensional structures
  • Discuss default drill up and drill down functionality
  • Give an example of when to override default drilling behavior
  • Configure advanced drill behavior
  • Define member sets
  • Create a Periods-To-Date report
  • Synchronize drill up and drill down in a multi-query report
  • Apply a single function to multiple member sets
  • Familiarize report authors with Report Studio interface using a standard TM1 data source
  • Discuss what metadata items need to be modified in TM1 Architect to better use TM1 data sources in Report Studio
  • Create/publish a TM1 package in IBM Cognos Framework Manager
  • Modify a TM1 cube for a Report Studio report
  • Demonstrate after modifications of a TM1 cube for Report Studio report
  • List additional TM1 cube for BI reporting considerations
  • Module 1: Dimensional Reporting Basics
  • Module 2: Introduction to Cube Data in Reports
  • Module 3: Report Context with a Cube Source
  • Module 4: Filtering Your Cube Sourced Report
  • Module 5: Functions and Calculations
  • Module 6: Navigating Hierarchies with Functions
  • Module 7: Navigating Dimensional Structures with Relative Functions
  • Module 8: Advanced Drill Up and Down and Member Sets
  • Appendix A: Advanced Exercises
  • Appendix B: Reports with TM1 Cubes