name :
B6252G
title :
IBM Cognos Framework Manager: Design Metadata Models (v11.1.x)
category :
Analytics
vendor :
IBM
classroomDeliveryMethod :
Classroom IBM
descriptions :
description :
OverviewThis 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.AudienceData ModelersPrerequisites
  • 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)
ObjectiveIntroduction 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 audienceCourse OutlineIntroduction 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
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.]
abstract :
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.
prerequisits :
objective :
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 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)
Objective 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
topic :
Course OutlineIntroduction 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
startDate :
2021-06-24T06:09:42Z
endDate :
2022-04-15T00:00:00Z
lastModified :
2021-06-23T08:00:42Z
created :
2019-01-10T08:00:50Z
duration :
32
durationUnit :
HOURS
ibmIPType :
listPrice :
currency :
badge_Template_ID :
3ef72dc6-d1d1-4f3b-a53f-daba9116d138
badge_Title :
IBM Cognos Framework Manager: Design Metadata Models (v11.1.x) - Code: B6252G
badge_Url :
https://www.credly.com/org/ibm/badge/ibm-cognos-framework-manager-design-metadata-models-v11-1-x-code-b6252g

    Enquire about this course: