> > > B5205G Detaillierte Beschreibung

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

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

Work with Different Query Subject Types
  • Identify key differences and 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 BI 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
Use Advanced Parameterization Techniques in Framework Manager
  • Identify environment and model session 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 and implement techniques to optimize and tune your Framework Manager models
  • Use Dynamic Query Mode in Framework Manager
Work in a Multi-Modeler Environment
  • Segment and link a project
  • Branch a project and merge results
Manage Framework Manager Packages
  • Specify package languages and function sets
  • Control model versioning
  • Nest packages
Appendix A: 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 10 content for use as a data source in Transformer
  • Create query sets
  • Use external source control through Windows Explorer
Appendix B: Model Multilingual Metadata
  • Customize metadata for a multilingual audience
Appendix C: Access Additional Resources
  • Links to sites where the customer can find more information about course-related material.