IBM Cognos Framework Manager Design Metadata Models v11.1.x B6252G

Duration: 
4 days
Codes: 
B6252G
Versions: 
V11.1.X

Overview

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using IBM Cognos 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

Data Modelers

Skills Gained

  • Introduction to IBM Cognos Framework Manager
  • Model for predictable results in IBM Cognos Framework Manager
  • Model for presentation in IBM Cognos Framework Manager
  • Advanced capabilities in IBM Cognos Framework Manager
  • Extended capabilities in IBM Cognos Framework Manager

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

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Manawatu-Wanganui Wellington4 5000 AU$5000 2019-12-16
Queensland Brisbane4 5000 AU$5000 2019-12-16
New South Wales Sydney4 5000 AU$5000 2019-12-16
Western Australia Perth4 5000 AU$5000 2019-12-16
Oroua County Auckland4 5000 AU$5000 2019-12-16
Australian Capital Territory Canberra4 5000 AU$5000 2019-12-16
Victoria Melbourne4 5000 AU$5000 2019-12-16
Manawatu-Wanganui Wellington4 5000 AU$5000 2020-01-28
Queensland Brisbane4 5000 AU$5000 2020-01-28
Australian Capital Territory Canberra4 5000 AU$5000 2020-01-28
New South Wales Sydney4 5000 AU$5000 2020-01-28
Western Australia Perth4 5000 AU$5000 2020-01-28
Oroua County Auckland4 5000 AU$5000 2020-01-28
Singapore Singapore4 5000 AU$5000 2020-01-28
Victoria Melbourne4 5000 AU$5000 2020-01-28
Queensland Brisbane4 5000 AU$5000 2020-03-16
Australian Capital Territory Canberra4 5000 AU$5000 2020-03-16
New South Wales Sydney4 5000 AU$5000 2020-03-16
Western Australia Perth4 5000 AU$5000 2020-03-16
Oroua County Auckland4 5000 AU$5000 2020-03-16
Victoria Melbourne4 5000 AU$5000 2020-03-16
Manawatu-Wanganui Wellington4 5000 AU$5000 2020-03-16
Singapore Singapore4 5000 AU$5000 2020-03-30