Test COG-632: IBM Cognos 10 BI Metadata Model Developer

The Cognos 10 BI Metadata Model Developer 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.

Common Data Structures and Traps (16%)

1. Identify Common Data Structures
2. Identify different data traps

Framework Manager Basics (16%)

1. Identify the different model types that can be published from Framework Manager
2. Define the purpose of Framework Manager
3. Create a project
4. Identify recommendations for preparing metadata

Predictable Results (16%)

1. Identify recommendations to achieve predictable results
2. Describe why and how to implement a time dimension
3. Identify techniques for creating intuitive business views

Security (9%)

1. Describe the Cognos 10 security environment
2. Describe how to implement security on models and packages

Project Management and Maintenance (5%)

1. Identify techniques for managing Framework Manager projects
2. Identify techniques for managing Framework Manager packages

Query Subject Types (9%)

1. Identify different query subject types and uses

Generated SQL and Complex Queries (17%)

1. Identify SQL Generation in Complex Queries
2. Identify aggregated result sets for multi-fact queries
3. Identify aggregations in Report Studio SQL

Optimization and Tuning (5%)

1. Describe the performance impact of queries

Advanced Techniques (7%)

1. Describe how to leverage user defined functions
2. Describe how to resolve a recursive relationship
3. Identify considerations for drill-through values and managing MUNs