ibm congos frame work

About Ibm Cognos Framework

Getting Start with IBM Cognos BI
  • Discuss IBM Cognos & Performance Management
  • IBM Cognos components
  • Describe IBM Cognos architecture at high level
  • Define IBM Cognos groups &  roles
  • Explain how to extend the  IBM Cognos
Identifying the Common Data Structures
  • Examine the characteristics of operational databases &  databases designed for reporting
  • Examine relationships & cardinality
  • Identifying the different data traps
  • Examine the dimensional data sources
  • Examine the key modeling recommendations
  • Define reporting_requirements
  • Explore the data sources to identify data access strategies
Create an Baseline Project
  • Examine the IBM Cognos BI & Framework Manager workflow processes
  • Define an project and its structure
  • Describe the Framework Manager environment
  • Create an baseline project
  • Enhance the model with the additional metadata
Prepare_Reusable Metadata
  • Identify facts & dimensions
  • Examine relationships, & data traps
  • Verify relationships &  query item properties
  • Efficient filters by configuring prompt properties
Model for Predictable Results_ Identify Reporting Issues
  • Describe multi-fact queries & when full outer joins are appropriate
  • How IBM Cognos BI uses the cardinality
  • Identifying the reporting traps
  • Use tools to analyze the model
Model for Predictable Results_Virtual Star Schemas
  • Identifying the advantages of modeling metadata as an star schema
  • Model_ layers
  • Create aliases to avoid the  ambiguous joins
  • Merge query subjects to create the  view behavior
Model for Predictable Results_ Consolidate Metadata
  •  virtual facts to simplify the writing queries
  •  virtual dimensions to resolve the fact-to-fact joins
  • Create an consolidated modeling layer for presentation purposes
  • Consolidate snowflake dimensions with the model query subjects
  • Simplify facts by hiding the unnecessary codes
Calculations & Filters
  • Use calculations to create an commonly-needed query items for authors
  • Use static filters to reduce   data returned
  • Use macros & parameters in calculations and filters to dynamically control the data
returned Implement an Time Dimension
  • Make time-based queries simple to author by implementing an time dimension
  • Resolve confusion caused by multiple relationships between an time dimension & another table Specify_ Determinants
  • Use determinants to specify multiple levels of granularity &  prevent double-counting


Creating Presentation View
  • Identify the dimensions associated with an fact table
  • Identify conformed v/s. non-conformed dimensions
  •  Create star schema groupings to provide authors with the  logical groupings of query
  • Rapidly create n model using the Model Design Accelerator
Working  with Different Query Subject Types
  • Identify key differences & recommendations for using data source, model, & stored procedure query subjects
  • Identify the effects on generated SQL when modifying query subjects, SQL settings & relationships Set Security in Framework Manager
  • Examine the IBM Cognos BI security environment
  • Restrict  the access to packages
  • Create &  apply security filters
  • Restrict access to the objects in the model
Create_Analysis Objects
  • Apply dimensional information to the relational Metadata to enable OLAP-style queries
  • Define members &  member unique names
  • Identify changes that impact an MUN
  • Sort members for presentation & predictability
Manage The OLAP Data Sources
  • Connect to an OLAP data source (cube) in an Framework Manager project
  • Publish   OLAP model
  • Publish an model with multiple OLAP data sources
  • Publish an model with an OLAP data source &  a relational data source
Advanced Generated SQL Concepts  &  Complex Queries
  • Governors that affect the SQL generation
  • Stitch_query SQL
  • Conformed & non-conformed dimensions in generated SQL
  • Multi-fact & multi-grain stitch query SQL
  • Variances in Report Studio generated SQL
  • The Dimensionally modeled relational SQL generation
  • Cross join Of SQL
  • Various results sets for the multi-fact queries
Use Of Advanced Parameterization Techniques in Framework Manger
  • Identify the environment & model session parameters
  • Leverage session, model, & custom parameters
  • Create an prompt macros
  • Leverage macro functions associated with the security
Model Maintenance &  Extensibility
  • Perform basic maintenance & management on a model
  • Remap metadata to the another source
  • Import & link a second data source
  • Run scripts to automate or update an model
  • Create an model report
Optimize ,Tune Framework Manager Models
  • Identify &  implement techniques to optimize and tune your Framework Manager models
  •  Use Dynamic Query Mode in the Framework ManagerWork in an Multi-Modeler
  • Segment &  link a project
  • Branch an project and merge results
Manage Framework Manager Packages
  • Specify package languages &  function sets
  • Control the model versioning
  • Nest_packages
Appendix A_ Employ Additional Modeling Techniques
  • Leverage an user defined function
  • Set the order of operations in an model calculation
  • Externalize query subjects
  • Prepare IBM Cognos 10 content for use as a data source in Transformer
  • Use of external source control through Windows Explorer
Appendix B_Model Multilingual Metadata
  • Customize metadata for an multilingual audience
  • Appendix C_ Additional_Resources