IBM Cognos Business Viewpoint 10.1: Manage Dimensions and Data SPVC

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