Course Description IBM Cognos Framework Manager: Designing Metadata Models is a three day instructor-led online course. This course provides participants with metadata modeling concepts and instruction on how to model metadata for predictable reporting and analysis using Framework Manager. Using a combination of lectures, instructor led demos, hands-on exercises, workshops and group exercises in a high-quality learning environment, participants will learn the full scope of metadata modeling process, from creating the initial project to enabling end users to author and analyze the data using the functionality of IBM Cognos BI. Price $1,495 USD Intended Audience This is an advanced course for developers of who design metadata models for IBM Cognos BI. Prerequisites Knowledge of your business requirements Knowledge of common industry standards for data structures and design Experience with SQL Experience gathering requirements and analyzing data Experience using IBM Cognos BI Report Studio (recommended)

Course Outline

• Module 1: Introduction to IBM Cognos 10 BI and Framework Manager
• Module 2 Preparing Metadata in Framework Manager
• Module 3: Relational Modeling in Framework Manager
• Module 4: Dimensional Modeling in Framework Manager

You will learn

• IBM Cognos BI Fundamentals
• Describe Cognos Connection
• Understand Modeling Basics
• Understand Framework Manager basics
• Understand Framework Manager Workflow
• Create a New Project and Import Metadata
• Prepare Metadata
• Understand Usage and Aggregate Properties
• Understand Relationships and Cardinality
• Create a Parameter Map
• Create a Filter and Calculation Namespace
• Create Stand Alone Filters
• Model Metadata in Framework Manager
• Understand Three Tier Framework Manager Model
• Model as a Star Schema
• Understand Model Query Subjects
• Use Model Query Subjects to Merge Snowflake Query Subjects
• Create True Facts and True Dimensions using Model Query Subjects
• Use Model Query Subjects for Business Friendly Information
• Add Calculations to Model Query Subjects
• Create Time Dimensions
• Understand Role Playing Dimensions
• Work with Determinants
• Create Presentation View in the model
• Understand Conformed Dimensions and Query Generation
• Define Dimensionally Modeled Relational (DMR) Metadata
• Understand Regular Dimensions
• Create Regular Dimensions based on Model Query Subjects
• Differentiate Query Subjects, Regular Dimensions and Determinants
• Creating Measure Dimensions
• Understand Scope Relationships
• Star Schema Groupings
• Create a Dimensional Reporting Package