IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

Test C2020-645: IBM Cognos 10 BI Multidimensional Author

The Cognos 10 BI Multidimensional Author Exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Dimensional Data Components (28%)

  1. Distinguish between relational, DMR, and dimensional data sources

  2. Identify dimensional data items and expressions

  3. Define multidimensional data structure components

  4. Describe the importance of report context

  5. Identify the default measure of a report

  6. Describe default members and their purpose

  7. Describe what a MUN is and identify the impact of using the wrong MUN

  8. Describe what a set is

  9. Describe what a tuple is

Focus Reports (14%)

  1. Distinguish between dimensional and relational filtering styles

  2. Identify techniques to focus data using the dimensional style

  3. Interpret data that is focused based on members

  4. Interpret data that is filtered based on measure values

  5. Describe the purpose of a slicer

Drilling in Reports (14%)

  1. Describe default drill-down behavior

  2. Describe default drill-up behavior

  3. Describe cases for advanced drilling configuration

  4. Appraise reports generated with calculations that are preserved during drilling

  5. Describe how member sets work

Drill-through Access (8%)

  1. Identify supported drill-through data item combinations

  2. Set-up drill-through access

  3. Describe a conformed dimension

Calculations and Dimensional Functions (36%)

  1. Describe the use of arithmetic operations in queries

  2. Analyze the use of dimensional functions in queries

  3. Examine coercion

  4. Apply prompts to focus reports

  5. Compose complex expressions that combine and reuse existing expressions


Connect with Us