> > > B5A05G Detaillierte Beschreibung

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

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

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