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