Course Outline
Unit 1: Create query models
- build query models and then connect them to the report layout
- edit an SQL statement to author custom queries
- add filters and prompts to a report using the query models
Unit 2: Create reports based on query relationships
- create reports by joining queries
- combine data containers based on relationships from different queries
Unit 3: Introduction to dimensional reporting concepts and dimensional data in reports
- List and describe the data model types
- Describe the OLAP data structure and elements
- Differentiate between report authoring styles
- use members to build reports
- identify and use sets and tuples in reports Unit 4: Dimensional report context
- understand report context
- root members
- default members
- current members
- default measures
- current measures
Unit 5: Focus your dimensional data
- understand how relational data sources behave
- understand how dimensional data sources behave
- create efficient queries
- understand filtering techniques
- use dimensional objects and functions
- create slicers and prompts
Unit 6: Calculations and dimensional functions
- understand the different types of dimensional functions within Cognos Analytics
- create reports utilizing dimensional functions
- use calculations within reports
Unit 7: Create advanced dynamic reports
- filter reports on session parameter values
- create dynamic headers and titles that reflect report data
- create a customer invoice report
Unit 8: Design effective prompts
- control report displays using prompts
- specify conditional formatting values using prompts
- create sorted and filtered reports based on prompt selection
Unit 9: Examine the report specification and distribute reports
- work with the report specification
- report specification flow
- considerations when modifying a report specification
- Create custom toolbox and template objects
- distribute reports using bursting
- create burst keys
- identify report recipients and data items using burst tables
- distribute reports using email and the IBM Cognos Analytics portal
Unit 10: Enhance user experience with HTML and Custom Controls
- create interactive reports by using HTML
- Include additional information with tooltips
- Send emails by using links in a report
- understand custom controls
- AMD models
- adding a custom control
- using JavaScript files
Unit 11: Advanced techniques
- understand advanced features
- booklet and reference reports
- table of contents
- tabbed reports
- classes and class extensions
- global parameters
- create a report binder
Objective
Unit 1: Create query models
- build query models and then connect them to the report layout
- edit an SQL statement to author custom queries
- add filters and prompts to a report using the query models
Unit 2: Create reports based on query relationships
- create reports by joining queries
- combine data containers based on relationships from different queries
Unit 3: Introduction to dimensional reporting concepts and dimensional data in reports
- List and describe the data model types
- Describe the OLAP data structure and elements
- Differentiate between report authoring styles
- use members to build reports
- identify and use sets and tuples in reports Unit 4: Dimensional report context
- understand report context
- root members
- default members
- current members
- default measures
- current measures
Unit 5: Focus your dimensional data
- understand how relational data sources behave
- understand how dimensional data sources behave
- create efficient queries
- understand filtering techniques
- use dimensional objects and functions
- create slicers and prompts
Unit 6: Calculations and dimensional functions
understand th...
