Booking options
Price on Enquiry
Price on Enquiry
Delivered Online
4 days
All levels
Duration
4 Days
24 CPD hours
This course is intended for
Data Modelers
Overview
Please refer to course 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 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.
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 (Optional)
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
Additional course details:
Nexus Humans B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.
This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.
Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.
While we feel this is the best course for the B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.
Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK....