IBM Certified Developer - Cognos 10 BI Metadata Models

Content

Module 1: Common Data Structures and Traps

The roles of a metadata model in Cognos BI, Characteristics of common data structures, Advantages of each model type, Relationships.

Module 2: Framework Manager Basics

Identify the different model types that can be published from Framework Manager, define the purpose of Framework Manager, create a project.

Module 3: Predictable Results

Identify the recommendations to achieve predictable results, describe why and how to implement a time duration, and to identify the techniques for creating intuitive business views.

Module 4: Security

Cognos 10 security environment and also discuss on how to implement security on models and packages.

Module 5: Project Management and Maintenance

Identify techniques for managing Framework Manager projects and also to identify techniques for managing Framework Manager Packages.

Module 6: Query Subject Types

Identify key differences and make recommendations for using data source, model and stored procedure query subjects and to identify the effects on generated SQL.

Module 7: Generated SQL and Complex Queries

Identify SQL generation in Complex Queries, identify aggregated results sets for multi-fact queries and to identify aggregations in Report Studio SQL.

Module 8: Optimization and Tuning

Identify and implement techniques to optimize and tune your Framework Manager models.

Module 9: Advanced Techniques

Resolve a recursive relationship, how to leverage User-defined functions and to identify castrations for drill-through values and managing immense.