Duration
4 days
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)
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.