> > > B5261G Detaillierte Beschreibung

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

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

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