Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

IBM Cognos Framework Manager: Design Metadata Models (v11.1.x)

  • Tuition USD $3,200
  • Reviews star_rate star_rate star_rate star_rate star_half 1552 Ratings
  • Course Code B6252G
  • Duration 4 days
  • Available Formats Classroom, Virtual
B6252G - IBM Cognos Framework Manager: Design Metadata Models (V11.1.X)

Course Eligible for IBM Digital Badge

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.

Skills Gained

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

Who Can Benefit

Data Modelers

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 Details

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

I attended two different trainings with ExitCertified - very happy and satisfied.

Program was well done from initial invitation to actual class and follow-up

The course on Redshift was excellent! As a DBA/DA I found there is a quite a bit of learning for Oracle professionals to move into AWS.

Great class, even better instructor!!!!! Standing ovation to Michael Staves!

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

3 options available

undo
  • GTR Jan 19, 2021 Jan 22, 2021 (4 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • GTR Feb 16, 2021 Feb 19, 2021 (4 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EST
    Enroll
    Enroll
  • Mar 15, 2021 Mar 18, 2021 (4 days)
    Location
    iMVP
    Language
    English
    Time
    9:30AM 5:30PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward