Základní info
BM Cognos 8 BI Report Studio: Author Reports with Multidimensional Data is an advanced two-day, instructor-led course in which you build on their experience with Report Studio by applying dimensional techniques to reports. Through hands-on demos and workshops, you will learn how to author reports that navigate and manipulate dimensional data structures using specific dimensional functions and features available in Report Studio.
Dostupnost tohoto kurzu v zahraničí
Kurz je určen pro:
This is an intermediate course for Professional Report Authors working with multidimensional data sources.
Předpokládané znalosti:
You should complete:
- IBM Cognos 8 BI Report Studio: Author Professional Reports Fundamentals (V8.4)
Obsah:
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
