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 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.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Please refer to course overview

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 (Optional)

  • 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

Audience

Data Modelers will benefit from this course.

Language

English

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.0.x) (recommended)

Length: 4.0 days (32 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...