IBM Cognos BI Framework Manager Advanced v10 (1 day)

Course Description

IBM Cognos Framework Manager Advanced is a one day course and can be delivered onsite or in instructor-led online format. This course provides participants an understanding of Security, Optimizing and Tuning Framework Manager Models.

Using a combination of lectures, instructor led demos and hands-on exercises in a high-quality learning environment, participants will learn the advanced modeling techniques using the functionality of IBM Cognos BI Framework Manager.

Price

$475 USD

May 25, 2012 9:00AM - 5:00PM CST

 ...paypal-credit-card-art

Intended Audience

This is an advanced course for developers of who design metadata models for IBM Cognos BI.

Prerequisites

  • Completed IBM Cognos Framework Manager: Designing Metadata Models (Version 10) or prior Framework Manager development experience
  • 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)
 button-talk-with-education-expert
product-framework-manager

Course Outline

  • Module 1: Securing the Framework Manager Model and Packages
  • Module 2: Optimize and Tune Framework Manager Models

You will learn

  • Understand SQL Generation with Query Subjects
  • Understand  Source Query Subject
  • Understand SQL Generation When Modifying Relationships
  • Understand Various SQL Type Settings
  • Understand SQL Generation in Complex Queries
  • Understand Multi-fact, Multi-grain SQL on Conformed Dimensions
  • Stitch Queries in Single and Multi-Fact Queries
  • Sett Security in Framework Manager
  • Manage Framework Manager Packages
  • Work with Materialized Views
  • Understand Minimized SQL
  • Set Limits on Query Execution using Governors
  • Create a Model with both Relational and OLAP Model
  • Understand Metadata Caching
  • Improve SQL Performance by Query Processing Techniques
  • Understand Rollup Processing and Aggregations
  • Manage Member Unique Names for DMR in Framework Manager
  • Model for Drill-Through in Framework Manager
  • Create Drill-Through Definitions
  • Analyze and Publish and OLAP Data Source