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

Course Outline

Introduction to IBM Cognos Framework ManagerModel data and identifying related dataDefine requirements and modeling strategiesOverview of IBM Cognos Framework ManagerCreate a baseline projectExtend a modelPrepare reusable metadataModel for predictable results in IBM Cognos Framework ManagerIdentify query issuesIdentify reporting trapsModel virtual star schemasUse query subjects, modify relationships, and consolidate metadata using virtual objectsCreate calculations, filter data, and customize metadata for runtimeImplement a time dimension and specify determinantsModel for presentation in IBM Cognos Framework ManagerCreate a presentation viewExamine data source query subject types and stored procedure query subject typesSpecify data security and package securitySpecify object security and dynamic data securityCreate analysis objectsManage OLAP data sourcesAdvanced capabilities in IBM Cognos Framework ManagerExplore SQL generation and the use of governorsExamine the use of IBM Cognos SQL and generated SQL for DMR dataOther query considerationsUse session parameters, prompt macros, and security macro functionsUse materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performanceExtended capabilities in IBM Cognos Framework ManagerPerform basic maintenance and management on a modelRemap metadata to another source and import and link additional data sourcesRun scripts to automate or update a model and report on a modelSegment a project, link a project, and branch a modelNest packages and specify package languages and functionsExplore additional modeling techniques and customize metadata for a multilingual audience

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