> > > B6159G Detailed outline

IBM Cognos Analytics: Author Reports Advanced (v11.0.x) (B6159G)

Course Description Schedule Course Outline

Detailed Course Outline

Create query models • Build a query and connect it to a report • Answer a business question by referencing data in a separate query

Create reports based on query relationships • Create join relationships between queries • Combine data containers based on relationships from different queries • Create a report comparing the percentage of change

Introduction to dimensional reporting concepts • Examine data sources and model types • Describe the dimensional approach to queries • Apply report authoring styles

Introduction to dimensional data in reports • Use members to create reports • Identify sets and tuples in reports • Use query calculations and set definitions

Dimensional report context • Examine dimensional report members • Examine dimensional report measures • Use the default measure to create a summarized column in a report

Focus your dimensional data • Focus your report by excluding members of a defined set • Compare the use of the filter() function to a detail filter • Filter dimensional data using slicers

Calculations and dimensional functions • Examine dimensional functions • Show totals and exclude members • Create a percent of base calculation

Create advanced dynamic reports • Use query macros • Control report output using a query macro • Create a dynamic growth report • Create a report that displays summary data before detailed data and uses singletons to summarize information

Design effective prompts • Create a prompt that allows users to select conditional formatting values • Create a prompt that provides users a choice between different filters • Create a prompt to let users choose a column sort order • Create a prompt to let users select a display type

Examine the report specification • Examine report specification flow • Identify considerations when modifying report specifications • Customize reporting objects

Distribute reports • Burst a report to email recipients by using a data item • Burst a list report to the IBM Cognos Analytics portal by using a burst table • Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship

Enhance user interaction with HTML • Create interactive reports using HTML • Include additional information with tooltips • Send emails using links in a report

Introduction to IBM Cognos Active Reports • Examine Active Report controls and variables • Create a simple Active Report using Static and Data-driven controls • Change filtering and selection behavior in a report • Create interaction between multiple controls and variables

Active Report charts and decks • Create an Active Report with a Data deck • Use Master detail relationships with Decks • Optimize Active Reports • Create an Active Report with new visualizations


Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!