Essentials for IBM Cognos Analytics: Supplement for Metadata Modelers (v11.0) (B6005G) – Outline

Detailed Course Outline

1: Working with Different Query Subject Types • identify the effects of modifying query subjects on generated SQL • specify two types of stored procedure query subjects • use prompt values to accept user input 2: Setting Security in Framework Manager • examine the IBM Cognos security environment • restrict access to packages • create and apply security filters • restrict access to objects in the model 3: Manage OLAP Data Sources • connect to an OLAP data source (cube) in a Framework Manager project • publish an OLAP model • publish a model with multiple OLAP data sources • publish a model with an OLAP data source and a relational data source 4: Advanced Generated SQL Concepts and Complex Queries • governors that affect SQL generation • stitch query SQL • conformed and non-conformed dimensions in generated SQL • multi-fact/multi-grain stitch query SQL • variances in Report Studio generated SQL • dimensionally modeled relational SQL generation • cross join SQL • various results sets for multi-fact queries 5: Using Advanced Parameterization Techniques • identify session and model parameters • leverage session, model, and custom parameters • create prompt macros • leverage macro functions associated with security 6: Model Maintenance and Extensibility • perform basic maintenance and management on a model • remap metadata to another source • import and link a second data source • run scripts to automate or update a model • create a model report 7: Optimize and Tune Framework Manager Models • identify how minimized SQL affects model performance • use governors to set limits on query execution • identify the impact of rollup processing on aggregation • apply design mode filters • limit the number of data source connections • use the quality of service indicator 8: Working in a Multi-Modeler Environment • segment and link a project • branch a project and merge results 9: Managing Packages in Framework Manager • Specifying package languages and function sets • Control model versioning • Nest packages Appendix A - Additional Framework Manager Modeling Techniques • leverage a user defined function • identify the purpose of query sets • use source control to manage Framework Manager files Appendix B - Modeling Multilingual Metadata • customize metadata for a multilingual audience