IBM COGNOS FRAMEWORK ONLINE TRAINING

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

     

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 week, 3 days
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details


      * Required

      Job Support

        Your Details


        * Required

        Course Features

        Live Instructor-led Classes

        This isn't canned learning. Its dynamic, its interactive, its effective

        Expert Educators

        Only the best or they're out. We are constantly evaluating our trainers

        24&7 Support

        We never sleep. Need something answered at 3 am? No Problem

        Flexible Schedule

        You don't learn as per our calendar. We work according to yours.

        Customized Training's

        The most part self-managed and adaptable to suit a person's particular adapting technology needs

        Priority Based Training's

        Real-time Scenario based Assignments and Case Studies

        COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED