Overview
IBM Cognos Framework Manager: Design Metadata Models: This course provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using 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.
Audience
Developers who design metadata models for use in IBM Cognos Analytics.
Prerequisite
• Knowledge of common industry-standard data structures and design.
• Experience with SQL
• Experience gathering requirements and analyzing data.
• IBM Cognos Analytics: Author Reports Fundamentals (recommended)
-
Module 1: Introduction to IBM Cognos Analytics
-
Module 2: Identifying common data structures
- Lesson 1: Define the role of a metadata model in Cognos Analytics
- Lesson 2: Distinguish the characteristics of common data structures
- Lesson 3: Understand the relative merits of each model type
- Lesson 4: Examine relationships and cardinality
- Lesson 5: Identify different data traps
- Lesson 6: Identify data access strategies
-
Module 3: Defining requirements
-
Module 4: Creating a baseline project
-
Module 5: Preparing reusable metadata
-
Module 6: Modeling for predictable results: Identifying reporting Issues
-
Module 7: Modeling for predictable results: Virtual star schemas
-
Module 8: Modeling for predictable results: consolidate metadata
-
Module 9: Creating calculations and filters
-
Module 10: Implementing a time dimension
-
Module 11: Specifying determinants
-
Module 12: Creating the presentation view
- Lesson 1: Identify the dimensions associated with a fact table
- Lesson 2: Identify conformed vs. non-conformed dimensions
- Lesson 3: Create star schema groupings to provide authors with logical groupings of query subjects
- Lesson 4: Rapidly create a model using the Model Design Accelerator
- Lesson 5: Rapidly create a model using the Model Design Accelerator
-
Module 13: Working with different query subject types
-
Module 14: Setting Security in Framework Manager
-
Module 15: Creating Analysis objects
-
Module 16: Managing OLAP Data Sources
-
Module 17: Advanced generated SQL concepts and complex queries
- Lesson 1: Governors that affect SQL generation
- Lesson 2: Stitch query SQL
- Lesson 3: Conformed and non-conformed dimensions in generated SQL
- Lesson 4: Multi-fact/multi-grain stitch query SQL
- Lesson 5: Variances in IBM Cognos Analytics – Reporting generated SQL
- Lesson 6: Dimensionally modeled relational SQL generation
- Lesson 7: Cross join SQL
- Lesson 8: Various results sets for multi-fact queries
-
Module 18: Using advanced parameterization techniques in Framework Manger
-
Module 19: Model maintenance and extensibility
-
Module 20: Optimizing and tuning Framework Manager models
- Lesson 1: Identify how minimized SQL affects model performance
- Lesson 2: Use governors to set limits on query execution
- Lesson 3: Identify the impact of rollup processing on aggregation
- Lesson 4: Apply design mode filters
- Lesson 5: Limit the number of data source connections
- Lesson 6: Use the quality of service indicator
-
Module 21: Working in a Multi-Modeler Environment
-
Module 22: Managing packages in Framework Manager
0.00 average based on 0 ratings