IBM B6252G - IBM Cognos Framework Manager: Design Metadata Models (v11.1.x)

Course Outline

Introduction to IBM Cognos Framework Manager

• Model data and identifying related data
• Define requirements and modeling strategies
• Overview of IBM Cognos Framework Manager
• Create a baseline project
• Extend a model
• Prepare reusable metadata

Model for predictable results in IBM Cognos Framework Manager

• Identify query issues
• Identify reporting traps
• Model virtual star schemas
• Use query subjects, modify relationships, and consolidate metadata using virtual objects
• Create calculations, filter data, and customize metadata for runtime
• Implement a time dimension and specify determinants

Model for presentation in IBM Cognos Framework Manager

• Create a presentation view
• Examine data source query subject types and stored procedure query subject types
• Specify data security and package security
• Specify object security and dynamic data security
• Create analysis objects
• Manage OLAP data sources

Advanced capabilities in IBM Cognos Framework Manager

• Explore SQL generation and the use of governors
• Examine the use of IBM Cognos SQL and generated SQL for DMR data
• Other query considerations
• Use session parameters, prompt macros, and security macro functions
• Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)
• DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performance

Extended capabilities in IBM Cognos Framework Manager

• Perform basic maintenance and management on a model
• Remap metadata to another source and import and link additional data sources
• Run scripts to automate or update a model and report on a model
• Segment a project, link a project, and branch a model
• Nest packages and specify package languages and functions
• Explore additional modeling techniques and customize metadata for a multilingual audience

Objective

Introduction to IBM Cognos Framework Manager

• Model data and identifying related data
• Define requirements and modeling strategies
• Overview of IBM Cognos Framework Manager
• Create a baseline project
• Extend a model
• Prepare reusable metadata

Model for predictable results in IBM Cognos Framework Manager

• Identify query issues
• Identify reporting traps
• Model virtual star schemas
• Use query subjects, modify relationships, and consolidate metadata using virtual objects
• Create calculations, filter data, and customize metadata for runtime
• Implement a time dimension and specify determinants

Model for presentation in IBM Cognos Framework Manager

• Create a presentation view
• Examine data source query subject types and stored procedure query subject types
• Specify data security and package security
• Specify object security and dynamic data security
• Create analysis objects
• Manage OLAP data sources

Advanced capabilities in IBM Cognos Framework Manager

• Explore SQL generation and the use of governors
• Examine the use of IBM Cognos SQL and generated SQL for DMR data
• Other query considerations
• Use session parameters, prompt macros, and security macro functions
• Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)
• DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performance

Extended capabilities in IBM Cognos Framework Manager

• Perform basic maintenance and management on a model
• Remap metadata to another source and import and link additional data sources
• Run scripts to automate or update a model and report on a model
• Segment a project, link a project, and branch a model
• Nest packages and specify package languages and functions
• Explore additional modeling techniques and customize metadata for a multilingual audience

Prerequisites

• Knowledge of common industry-standard data structures and design
• Experience with SQL
• Experience gathering requirements and analyzing data
• IBM Cognos Analytics: Author Reports Fundamentals (v11.1.x) (recommended)

Audience

Data Modelers