Essentials for IBM Cognos BI: Supplement for Metadata Modelers (V10.2.2)

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

Setting Security in Framework Manager

• Examine the IBM Cognos 10 security environment
• Restrict access to packages
• Create and apply security filters
• Restrict access to objects in the model

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

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

Using Advanced Parameterization Techniques

• Identify session and model parameters
• Leverage session, model, and custom parameters
• Create prompt macros
• Leverage macro functions associated with security

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

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

Working in a Multi-Modeler Environment

• Segment and link a project
• Branch a project and merge results

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