IBM Cognos 8 BI Report Studio: Author Reports with Multidimensional Data (V8.4)

• kurz IBM
• délka kurzu: 2 dny
• cena: 23600 CZK
• kategorie: IBM/cognos

Nejbližší termíny:

Kurz není v nejbližší době naplánován. Kontaktujte nás a pokusíme se Vám vyjít vstříc.

Podrobnosti:

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čí

• IBM Cognos Express 9.0 / 9.5 – Administrator Role
• IBM Cognos Express 9.0/9.5 – User Role

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