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

    Drop us a query

    Job Support

    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

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information

    475-212-0075

    +91 9989754807

    trainings@keentechnologies.com


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2019 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    X