Loading...

B6152G – IBM Cognos Framework Manager: Design Metadata Models (v11.0.x)

Home / B6152G – IBM Cognos Framework Manager: Design Metadata Models (v11.0.x)

Course Outline:

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 (Optional)

- 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

Course Audience & Prerequisites:

Audience

  • Data Modelers

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.0.x) (recommended)

Course Offerings:

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.

  • Course Outline
  • Course Audience & Prerequisites
  • Course Offerings
  • Related Courses

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 (Optional)

- 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

Audience

  • Data Modelers

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.0.x) (recommended)

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.

B6058G – IBM Cognos Analytics: Author Reports Fundamentals

This course provides professional report authors an opportunity to learn the fundamentals of report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Demonstrations and exercises will illustrate and reinforce key concepts during this learning opportunity.

B6059G – IBM Cognos Analytics: Author Reports Advanced

This course teaches Professional Report Authors about advanced report building techniques using relational data models, and ways of enhancing, customizing, and managing professional reports. The course builds on topics presented in the Fundamentals course. Students will participate in interactive demonstrations and exercises that illustrate key concepts while learning how to use advanced features in the product builds on topics learned in the Fundamentals course.

B6052G – IBM Cognos Framework Manager: Design Metadata Models

This course provides students with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager in Cognos Analytics. Students will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the Web, enabling end users to easily author reports and analyze data.

B6158G – IBM Cognos Analytics: Author Reports Fundamentals (V11.0.X)

This course provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

B6159G – IBM Cognos Analytics: Author Reports Advanced (V11.0.X)

This course teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.

B6152G – IBM Cognos Framework Manager: Design Metadata Models (v11.0.x)

This course provides students with introductory to advanced knowledge of metadata modeling concepts for predictable reporting and analysis of results using Framework Manager. Students will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.

B6258G – IBM Cognos Analytics: Author Reports Fundamentals (V11.1.x)

This course provides business and professional authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

B6259G – IBM Cognos Analytics: Author Reports Advanced (V11.1.x)

This course teaches professional report authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.

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

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using IBM Cognos Framework Manager. Students will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.