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

dettagliati del corso
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