In this section

Share this page

IBM Certified Designer - Cognos 10 BI Multidimensional Reports

The professional report author is responsible to work with multidimensional data sources and apply dimensional techniques to reports.

The Cognos 10 BI Multidimensional Author Exam covers key concepts, technologies, and functionality of the Cognos products.


  • Experience with basic Windows and web functionality
  • Create simple list, crosstab, or chart reports

Recommended Training and Required Exam(s)

 Required Exam Recommended Training 
COG-645 - IBM Cognos 10 BI Multidimensional Author
  • IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.1) (B5161G)
  • IBM Cognos Report Studio: Author Reports with Multidimensional Data (V10.2) (B5261G)

Skills acquired during recommended training

Dimensional Data Components

  • Distinguish between relational, DMR, and dimensional data sources
  • Identify dimensional data items and expressions
  • Define multidimensional data structure components
  • Define the importance of report context
  • Identify the default measure of a report
  • Describe default members and their purpose
  • Describe what a MUN is and identify the impact of using the wrong MUN
  • Describe what a set is
  • Describe what a tuple is

Focus Reports

  • Distinguish between dimensional and relational filtering styles
  • Focus data using the dimensional style
  • Interpret data that is focused based on members
  • Interpret data that is filtered based on measure values
  • Describe the purpose of a slicer

Drilling in Reports

  • Default drill-down behavior
  • Default drill-up behavior
  • Advanced drilling configuration
  • Appraise reports generated with calculations that are preserved during drilling
  • Describe how member sets work

Drill-through Access

  • Identify supported drill-through data item combinations
  • Set-up drill-through access
  • Describe a conformed dimension

Calculations and Dimensional Functions

  • Use arithmetic operations in queries
  • Analyze the use of dimensional functions in queries
  • Examine coercion
  • Apply prompts to focus reports
  • Compose complex expressions that combine and reuse existing expressions