> > > B5261G Detailed outline

IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.2) (B5261G)

Course Description Schedule Course Outline

Detailed 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
  • Use functions to traverse the dimensional hierarchies
  • Create reports with children(), ancestor(), and descendants() functions
Relative Functions
  • Understand relative functions
  • Create periods-to-date reports
  • Focus reports on current time periods
  • Compare data to past parallel time periods
Advanced Drilling Techniques and Member Sets
  • Review basic drilling up and drilling down
  • Identify cases for advanced drilling configurations
  • Enable advanced drilling behavior
  • Preserve report sort order when drilling
  • Preserve complex calculations when drilling
  • Maintain dashboard report context when drilling
Set Up Drill-Through Reports
  • Drill through from one report to another
  • Create package-based drill-through
  • Design source and target reports with dimensional data
  • Drill through from dimensional data to relational data
  • Create a single report with data from multiple sources
End-to-End Workshop
  • Review concepts covered throughout the course