IBM COGNOS FRAMEWORK ONLINE TRAINING COURSE CONTENT

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

REQUIREMENTS

• 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

SUBJECTS

• 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