IBM Cognos Analytics – Author Reports with Multidimensional Data (V11.0)
Audience
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
Key Topics
- 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
- Work with members
- Identify sets and tuples in IBM Cognos Analytics
- Understand the purpose of report context
- Understand how data is affected by default and root members
- 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
- Use IBM Cognos Analytics dimensional functions to create sets and tuples
- Perform arithmetic operations in OLAP queries
- Identify coercion errors and rules
- Navigate dimensional data using family functions
- Navigate dimensional data using relative functions
- Navigate dimensional data using relative time functions
- 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
- 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
- Review concepts covered throughout the course
Request a Class
Please complete all fields.
1