Search this site

    SAP ONLINE TRAINING

    Cognos Online Training


    Cognos Online Training

    COGNOS online training is available on weekends and weekdays in US evening hours.


    Cognos Course Content:

    INTRODUCTION TO DATAWARE HOUSING (DWH)

    Introduction to DWH
    Characteristics of DWH
    OLTP Vs OLAP Databases
    Different Approaches of DWH (Kimball VsInmon)
    Data mart Vs Data Warehouse
    Fact Table Vs Dimension Table
    Concepts of Schemas (Star schema & Snowflake schema)
    Industry leading ETL and Reporting tools

    INTRODUCTION TO COGNOS

    About Cognos 8.4
    3 – Tier Architecture
    Cognos Release (EP series7, Reportnet ,Cognos 8.0/8,1/8.2/8.3) and their differences
    Features of Cognos 8.4
    CognosVs other OLAP tools
    Cognos components (Modeling& Reporting)
    Different cognos services

    COGNOS CONNECTIONS

    Personalize cognos connection
    Create and manage portals, shortcuts, report views..etc
    Working with Cognos configuration, content Store
    How to Connect to different Data Sources
    Security setup
    Import and Export of Package (Deployment)
    Running the Report Burn
    Scheduling Reports

    FRAMEWORK MANAGER

    About Framework Manager
    Framework Manager, Metadata Modeling
    Creation of Interface and Usage
    Creating Model & Namespace (Layers)
    Importing Metadata
    Naming convention for objects in a project
    Creating Query Subjects & Query Items
    Merging Query Subjects
    Creating Relationships & Setting Cardinalities
    Creating Parameter Maps & Macros
    Creating of Model Filters, Prompts & Calculations
    Add Business Rules and Set Governors
    Assigning package level security
    Improving performance
    Publishing Package

    QUERY STUDIO

    Introduction
    About Ad-hoc Reports
    Types of Report(List, Cross Tab, Chart Reports & Others)
    Applying Filters, Prompts & Calculations
    Sorting, Grouping, Sections & Aggregate Functions
    Run and Manage reports

    REPORT STUDIO

    Type of Report Templates
    Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
    Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
    Generating and Creating Prompt Page
    Types of Prompts
    Query Calculations & Layout Calculations
    Filters and Dynamic Filters
    Conditional Block
    Conditional Formatting
    Master Details
    Cascading Prompt
    HTML Items & Hyperlinks
    Set Operators
    Setting Burst Options
    Drill through
    Drill up & Drill down
    Setting Variables
    Report Functions
    Report Validation
    Reports Run with Options

    ANALYSIS STUDIO

    Insert Data
    Change the number of Visible Items
    Nest Data
    Replace Data
    Sort Data
    Explore Data
    Change the measure
    Drill down for Details
    Hide Items
    Insert a calculation
    Save a custom set
    Define a filter
    Compare sets of data
    Using Dynamic Context

    EVENT STUDIO

    Creating Agents
    Adding Event conditions
    Task and Task execution rules
    Scheduling Agents