Reporting Authoring Against Dimensional Data (IBM Cognos Analytics)

Reporting Authoring Against Dimensional Data (IBM Cognos Analytics)


Users who need to create and develop reports (authors) within IBM Cognos Analytics Reporting against a dimensional data source. This course is provided to give new users of Cognos Analytics an overview of the user interface, together with in depth knowledge of basic and more advanced authoring techniques and functions against a Dimensional Data source.


None, however it would be beneficial to be familiar with a web browser and comfortable with using laptops/PC’s and a mouse.


2 days. Hands on.

Course Objectives

The objectives of this course are:

  • To provide an Introduction to Business Intelligence/Analytics
  • To be able to describe how the various Cognos Analytical tools can be used against a typical BI requirement, overviews on Dashboards, Data Modules and Stories
  • To provide an overview of Reporting within Cognos Analytics
  • To develop a range of skills within Reporting that will enable the user to create/author reports against a cube/dimensional data

Course Content

Discuss and provide an overview of Business Analytics

Overview of Cognos Analytics, covering the Connection Portal, general navigation and understanding of the interface and features available within the analytics tool

Introduction to the Reporting interface and overview of workshops

Understanding the differences between Relational/Dimensional techniques, creation of sql/mdx

Understanding dimensional reporting concepts, MUNs, members functions and queries

Utilising and discussing various methods that can be used whilst building your reports

Creation of basic reports, introduction to lists, crosstabs and charts within Reporting

Dimensional Terminology and setting up the report context, filtering using dimensional techniques, including sets, slicers and tuples

Utilising dimensional and relative functions to assist with report development against a dimensional data source

Creating hard coded and parameterised filters and the creation of prompts and prompt pages

Setting up variables, general formatting and conditional formatting

Understanding hierarchies and drill down/up and through options, general navigation

Course Review and Feedback, including recap and Q/A session

Virtual Courses

ALL of our courses can be delivered virtually! Our Bath public schedule courses are available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at:

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...