IBM COGNOS FRAMEWORK ONLINE TRAINING
0 STUDENTS ENROLLED
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
Course Reviews
No Reviews found for this course.
Write a Review