We are happy to advise you!
+49 40 253346-10     Contact
> > > B6252G Detailed outline

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

Detailed 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

 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!