Essentials for IBM Cognos BI: Supplement for Metadata Modelers (10.1) SPVC

Work with Different Query Subject Types

• Identify key differences and make recommendations for using data source, model, and stored procedure query subjects
• Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships

Set 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

Manage MUNs in Framework Manager

• Describe model types and data entities
• Define members and member unique names
• Identify changes that impact a MUN

Model for Drill Through in Framework Manager

• Describe model types and data entities
• Define members and member unique names
• Identify changes that impact a MUN

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

Use Advanced Parameterization Techniques in Framework Manager

• identify session and model parameters
• leverage session, model, and custom parameters
• create prompt macros
• leverage macro functions associated with security environment

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
• View lineage
• Create a model report

Optimize and Tune Framework Manager Models

• Identify and implement techniques to optimize and tune your Framework Manager models

Work in a Multi-Modeler Environment

• Implement repository control
• Segment and link a project
• Branch a project and merge results

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

Manage Framework Manager Packages

• Specify package languages and function sets
• Control model versioning
• Nest packages

Employ Additional Framework Manager Modeling Techniques

• Leverage a user defined function
• Set the order of operations in a model calculation
• Externalize query subjects
• Prepare IBM Cognos content for use as a data source in Transformer
• Create query sets

Model Multilingual Metadata

• Customize metadata for a multilingual audience

Access Additional Resources