Course description: IBM Cognos Business Viewpoint 10.1: Manage Dimensions and Data

IBM Cognos Business Viewpoint 10.1: Manage Dimensions and Data is a two-day, instructor-led course in which participants will learn to manage dimensions across the enterprise. Participants will import data and create dimensions, hierarchies, levels, and attributes. In addition, students will create workflows, reconcile nominated data, and move fact data into a TM1 cube. Participants will also publish and distribute the dimensions and data to other applications or users.

View this course in other countries

Training Paths that reference this course are:

• IBM Cognos Business Viewpoint 10.1 – Modeler & Administrator Role
• IBM Business Viewpoint 10.1 - Administrator
• IBM Business Viewpoint 10.1 - Modeler

Back to top

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - online account

Back to top

This intermediate course is intended for Modelers.

Back to top

You should have:

• Basic knowledge of dimensional modeling
• Basic knowledge of the IBM Cognos modeling tools used in your environment such as IBM Cognos Planning,  IBM Cognos TM1,  IBM Cognos Transformer, or  IBM Cognos Framework Manager (recommended)

Back to top

Please refer to course overview.

Back to top

Introduction to IBM Cognos Business Viewpoint

• Identify some of the problems associated with managing dimensions
• Identify three capability areas that enable IBM Cognos Business Viewpoint to address these problems
• Identify tools that are used with IBM Cognos Business Viewpoint
• Examine best practices to get started

Model Dimensional Objects

• Identify Business Viewpoint components
• Use systems
• Create dimensions with lists and hierarchies
• Create a dimension template
• Create versions of dimensions

Enhance Dimensions

• Modify members in a dimension using comments, views, filters and search
• Modify static and dynamic hierarchies
• Add attributes
• Add validation rules to an attribute
• Create calculated attributes
• Work with sets

Use Business Viewpoint Client to Synchronize Data

• Explain the purpose of Business Viewpoint Client adapters
• Nominate data
• Subscribe to data
• Compare import with nominate and subscribe
• Integrate with IBM Cognos modeling tools

Manage the Dimension Change Process

• Explain the four steps in the workflow process
• Use workflows to check the progress of tasks
• Review data and reconcile data using merge

Move Fact Data Into IBM Cognos TM1

• Describe fact data
• Match dimensions in your source and target data store
• Create and run links to move fact data from your source to your target

Integrate with IBM Cognos BI

• Integrate with IBM Cognos reporting tools
• Publish a dimension to an IBM Cognos package, to a Framework Manager model and to a CSV file

Back to top