IBM Cognos Framework Manager: Design Metadata Models (v11.0.x) SPVC - J4152G

Description

Contains PDF course guide, as well as a lab environment where students can work through demonstrations and exercises at their own pace.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. http://www.ibm.com/training/terms

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

Aim

Please refer to course overview

Participant requirements

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)

Participant

Data Modelers