This course guides the student into creating a complex data structure that will be used to create reports using IBM Cognos Analytics. The student will learn how to create a model that will specifically address the business need of a reporting environment. The student will learn how to avoid different data traps and will learn how to implement techniques to create an efficient model.
Course is $2990.00
Introduction to Framework Manager
- Explain Framework Manager
- Interface described
- Query Modes
- Model Types
- Query Types
Gather Business and Data requirements
- Examine Modeling recommendations
- Identify business requirements
- Satisfy Data requirements
- Working in Stages
Create a Project
- Describe Cardinality
- Configure Model Query Subjects
- Describe Stitch Query behavior
- Identity Data Traps
Model your Business with Virtual Facts and Dimensions
- Create user friendly virtual facts
- Make virtual dimensions for Multi-Fact reporting
- Create a Layering system for model management
Calculations and Filters
- Create Calculations for business requirements
- Create Filters to reduce target data
Implement a Time Dimension
- Configuring a Time Dimension
- Address Challenges with Uneven Granularity
- Specify Determinants
Create Analysis Objects
- Apply OLAP style functionality to relational metadata
- Regular and Measure Dimensions
- Defining Scope
- Sort members for presentation and predictability
Creating a Dimensional Layer
Framework Manager Security
- Setting up Package Security
- Learning about Object Security
- Applying Data Security