{"course":{"productid":19958,"modality":6,"active":true,"language":"de","title":"IBM Cognos Framework Manager: Design Metadata Models (v11.1.x)","productcode":"B6252G","vendorcode":"IB","vendorname":"IBM","fullproductcode":"IB-B6252G","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/ibm-b6252g","essentials":"<ul>\n\n\t<li>Knowledge of common industry-standard data structures and design<\/li><li>Experience with SQL<\/li><li>Experience gathering requirements and analyzing data<\/li><li>IBM Cognos Analytics: Author Reports Fundamentals (v11.1.x) (recommended)<\/li><\/ul>","audience":"<p>Data Modelers<\/p>","contents":"<p>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.<\/p>","outline":"<p>Introduction to IBM Cognos Framework Manager&bull; Model data and identifying related data&bull; Define requirements and modeling strategies&bull; Overview of IBM Cognos Framework Manager&bull; Create a baseline project&bull; Extend a model&bull; Prepare reusable metadataModel for predictable results in IBM Cognos Framework Manager&bull; Identify query issues&bull; Identify reporting traps&bull; Model virtual star schemas&bull; Use query subjects, modify relationships, and consolidate metadata using virtual objects&bull; Create calculations, filter data, and customize metadata for runtime&bull; Implement a time dimension and specify determinantsModel for presentation in IBM Cognos Framework Manager&bull; Create a presentation view&bull; Examine data source query subject types and stored procedure query subject types&bull; Specify data security and package security&bull; Specify object security and dynamic data security&bull; Create analysis objects&bull; Manage OLAP data sourcesAdvanced capabilities in IBM Cognos Framework Manager&bull; Explore SQL generation and the use of governors&bull; Examine the use of IBM Cognos SQL and generated SQL for DMR data&bull; Other query considerations&bull; Use session parameters, prompt macros, and security macro functions&bull; Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)&bull; DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performanceExtended capabilities in IBM Cognos Framework Manager&bull; Perform basic maintenance and management on a model&bull; Remap metadata to another source and import and link additional data sources&bull; Run scripts to automate or update a model and report on a model&bull; Segment a project, link a project, and branch a model&bull; Nest packages and specify package languages and functions&bull; Explore additional modeling techniques and customize metadata for a multilingual audience<\/p>","essentials_plain":"- Knowledge of common industry-standard data structures and design\n- Experience with SQL\n- Experience gathering requirements and analyzing data\n- IBM Cognos Analytics: Author Reports Fundamentals (v11.1.x) (recommended)","audience_plain":"Data Modelers","contents_plain":"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.","outline_plain":"Introduction to IBM Cognos Framework Manager\u2022 Model data and identifying related data\u2022 Define requirements and modeling strategies\u2022 Overview of IBM Cognos Framework Manager\u2022 Create a baseline project\u2022 Extend a model\u2022 Prepare reusable metadataModel for predictable results in IBM Cognos Framework Manager\u2022 Identify query issues\u2022 Identify reporting traps\u2022 Model virtual star schemas\u2022 Use query subjects, modify relationships, and consolidate metadata using virtual objects\u2022 Create calculations, filter data, and customize metadata for runtime\u2022 Implement a time dimension and specify determinantsModel for presentation in IBM Cognos Framework Manager\u2022 Create a presentation view\u2022 Examine data source query subject types and stored procedure query subject types\u2022 Specify data security and package security\u2022 Specify object security and dynamic data security\u2022 Create analysis objects\u2022 Manage OLAP data sourcesAdvanced capabilities in IBM Cognos Framework Manager\u2022 Explore SQL generation and the use of governors\u2022 Examine the use of IBM Cognos SQL and generated SQL for DMR data\u2022 Other query considerations\u2022 Use session parameters, prompt macros, and security macro functions\u2022 Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)\u2022 DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performanceExtended capabilities in IBM Cognos Framework Manager\u2022 Perform basic maintenance and management on a model\u2022 Remap metadata to another source and import and link additional data sources\u2022 Run scripts to automate or update a model and report on a model\u2022 Segment a project, link a project, and branch a model\u2022 Nest packages and specify package languages and functions\u2022 Explore additional modeling techniques and customize metadata for a multilingual audience","skill_level":"Intermediate","version":"1","duration":{"unit":"d","value":4,"formatted":"4 Tage"},"pricelist":{"List Price":{"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":3400}}},"lastchanged":"2026-03-12T14:29:08+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/json-course-schedule\/19958","source_lang":"de","source":"https:\/\/portal.flane.ch\/swisscom\/json-course\/ibm-b6252g"}}