IBM Cognos Analytics - Author Reports with Multidimensional Data (V11.0)
Skills Gained
- Compare dimensional and relational data sources
- Understand dimensional concepts and reporting styles
- Create reports using dimensional data items such as members, levels, and hierarchies
- Focus reports using dimensional techniques such as edge filters, slicers, and filter functions
- Navigate dimensional data structures using functions to find related members or comparison time periods
- Create sophisticated measure calculations
- Understand totals and aggregation
- Analyze reports with drill-up and drill-down techniques
- Configure advanced drilling behavior to support complex calculations and dashboard reports
- Set up drill-through access from one data source to another
Who Can Benefit
Report authors working with dimensional data sources.
Prerequisites
- IBM Cognos Analytics: Author Reports Fundamentals (v11.0)
- Knowledge of your business requirements
- Knowledge of dimensional data
Course Outline
1. Introduction to Dimensional Concepts
- Identify different data sources and models
- Investigate the OLAP dimensional structure
- Identify dimensional data items and expressions
- Differentiate the IBM Cognos Analytics query language from SQL and MDX
- Differentiate relational and dimensional report authoring styles
2. Introduction to Dimensional Data in Reports
- Work with members
- Identify sets and tuples in IBM Cognos Analytics
3. Dimensional Report Context
- Understand the purpose of report context
- Understand how data is affected by default and root members
4. Focus Your Dimensional Data
- Compare dimensional queries to relational queries
- Explain the importance of filtering dimensional queries
- Evaluate different filtering techniques
- Filter based on dimensions and members
- Filter based on measure values
- Filter using a slicer
5. Calculations and Dimensional Functions
- Use IBM Cognos Analytics dimensional functions to create sets and tuples
- Perform arithmetic operations in OLAP queries
- Identify coercion errors and rules
6. Functions for Navigating Dimensional Hierarchies
- Navigate dimensional data using family functions
7. Relative Functions
- Navigate dimensional data using relative functions
- Navigate dimensional data using relative time functions
8. Advanced Drilling Techniques and Member Sets
- Understand default drill-up and drill-down functionality
- Identify cases when you need to override default drilling behavior
- Configure advanced drilling behavior to support sophisticated use cases
- Define member sets to support advanced drilling
- Define member sets to support functions
9. Set Up Drill-Through Reports
- Navigate from a specific report to a target report
- Drill down to greater detail and then navigate to target report
- Navigate between reports created using different data sources
10. End-to-End Workshop
- Review concepts covered throughout the course
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date