Course Overview
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. Participants 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.
Course Objectives
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
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
1 - 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
2 - 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
3 - 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
4 - 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
5 - 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