Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

IBM Cognos Framework Manager - Design Metadata Models

( Duration: 4 Days )

This IBM Cognos Framework Manager training course provides knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. You will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web and enabling end users to easily author reports and analyze data through hands-on activities.

By attending IBM Cognos Framework Manager workshop, delegates will learn to:

  • Overview of Cognos Framework Manager
  • Modeling for predictable results
  • Modeling for presentation views
  • Advanced and extended capabilities

  • Knowledge of common industry-standard data structures and design
  • Experience with SQL
  • Experience gathering requirements and analyzing data
  • Knowledge of IBM Cognos Analytics: Author Reports

The IBM Cognos Framework Manager class is ideal for:

  • Data Modelers

COURSE AGENDA

1

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
2

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
3

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
4

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
5

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X