Training IBM Cognos Analytics: Author Reports Advanced (V11.1.x)

Learn advanced techniques for creating reports.

Report authors and business analysts

Creating query models

• Create a query and link it to a report
• Answer the business question by referring to the data in a separate query

Create reports based on query relationships

• Create connection relationships between queries
• Combining data containers based on relationships from different queries
• Create a report comparing the percentage of change

Introduction to the concept of dimensional reporting

• Study of data sources and model types
• Describing a dimensional approach to queries
• Use of styles to create reports

Introduction to dimensional data in reports

• Using members to create reports
• Identifying sets and tuples in reports
• Using query calculations and set definitions

The context of the dimensional report

• Study of dimension report elements
• Study of dimension report measures
• Using default measures to create a summary column in a report

Concentrating your dimensional data

• Focus your report by excluding members of the defined set
• Compare the use of the filter function with the detail filter
• Filter dimensional data with slicers

Calculations and dimension functions

• Study of dimensional functions
• Showing totals and excluding members
• Creation of base percentage calculation

Create advanced dynamic reports

• Using query macros
• Control the results of reports using a query macro
• Create a dynamic growth report
• Create a report that displays summary data before detail data and uses singletons to summarize the information

Designing effective reminders

• Create a prompt that allows users to select conditional formatting values
• Create a prompt that provides users with a choice between different filters
• Create a prompt to allow users to choose the sort order of the columns
• Create a prompt to allow users to select a display type

Examination of report specifications

• Examine the flow of report specifications
• Identify issues to consider when modifying report specifications
• Customize reporting objects

Distribution of reports

• Distribute the report to email recipients using the data element
• Distribute the list report to the IBM Cognos Analytics portal using a dashboard
• Distribute the cross table report to the IBM Cognos Analytics portal using a dashboard and a master-detail relationship

Improve user interaction with HTML

• Create interactive reports with HTML
• Include additional information with prompts
• Send emails using links in the report

Introduction to IBM Cognos Active Reports

• Examination of Active Report controls and variables
• Create a simple Active Report using static and data-driven controls
• Change the filtering and selection behavior in the report
• Create interactions between multiple controls and variables

Charts and active report sets

• Create an active report with a set of
• Create active report with visualizations 11.0

What you will learn

• How to create query models and reports based on query relationships
• Dimensional reporting concepts
• Dimensional data in reports and report context
• How to focus dimensional data
• Calculations and dimension functions
• Create advanced dynamic reports
• Designing effective reminders
• Examination of report specifications
• Distribution of reports
• Improving user interaction with HTML
• Introduction to IBM Cognos Active Reports
• Charts and active report sets

Although the class exercises are performed in a Cognos Analytics v11.1 environment, our experienced instructors can provide guidance on previous Cognos versions and their differences.

You should have:

• Previous experience using IBM Cognos Analytics
• Knowledge of business requirements
• Experience using the Windows operating system
• Experience in using a web browser
• https://eitt.pl/technologie/overview-of-ibm-cognos-analytics-v11-2/