IBM Cognos Analytics: Author Reports Advanced (v11.2)

Module 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

Module 2: Create reports based on query relationships

• Create reports by joining queries
• Combine data containers based on relationships from different queries

Module 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

Module 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

Module 6: Calculations and dimensional functions

• Understand the different types of dimensional functions within Cognos Analytics
• Create reports utilizing dimensional functions
• Use calculations within reports

Module 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

Module 8: Design effective prompts

• Control report displays using prompts
• Specify conditional formatting values using prompts
• Create sorted and filtered reports based on prompt selection

Module 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

Module 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

Module 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