Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    C8RMFT-01-Overview of Cognos8 BI

    Uploaded by

    Ravindra Muddana
    Cognos 8 BI is a business intelligence software solution that provides integrated reporting, analysis, scorecarding, and event management capabilities. It includes different studios for metrics, queries, reports, analysis, and events. It can access various data sources and features dimensional reporting, comparative analysis, dashboards, self-service reporting, and event management. The data can be transformed and modeled dimensionally from relational sources for analysis across the studios.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    C8RMFT-01-Overview of Cognos8 BI

    Uploaded by

    Ravindra Muddana
    46 views24 pages
    Cognos 8 BI is a business intelligence software solution that provides integrated reporting, analysis, scorecarding, and event management capabilities. It includes different studios for metrics, queries, reports, analysis, and events. It can access various data sources and features dimensional reporting, comparative analysis, dashboards, self-service reporting, and event management. The data can be transformed and modeled dimensionally from relational sources for analysis across the studios.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Cognos 8 BI is a business intelligence software solution that provides integrated reporting, analysis, scorecarding, and event management capabilities. It includes different studios for metrics, queries, reports, analysis, and events. It can access various data sources and features dimensional reporting, comparative analysis, dashboards, self-service reporting, and event management. The data can be transformed and modeled dimensionally from relational sources for analysis across the studios.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    46 views24 pages

    C8RMFT-01-Overview of Cognos8 BI

    Uploaded by

    Ravindra Muddana
    Cognos 8 BI is a business intelligence software solution that provides integrated reporting, analysis, scorecarding, and event management capabilities. It includes different studios for metrics, queries, reports, analysis, and events. It can access various data sources and features dimensional reporting, comparative analysis, dashboards, self-service reporting, and event management. The data can be transformed and modeled dimensionally from relational sources for analysis across the studios.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 24

    Overview of Cognos 8 BI

    Cognos 8 BI

    Objectives
    In this module, we will:

    review Corporate Performance Management introduce Cognos 8 BI examine the different studios in Cognos 8 BI identify the different data sources within the studios highlight key capabilities of Cognos 8 BI

    Review the Process for Decision Making


    Why are we doing it? What should we be doing?

    How are we doing?

    Scorecarding & Dashboarding

    Reporting & Analysis

    High-frequency Planning

    Single Platform for Decision Making

    Corporate Performance Management System


    PERFORMANCE MANAGEMENT SOLUTIONS

    Industry Solutions

    Enterprise Performance Solutions

    BEST PRACTICES
    How are we doing? Why are we doing it? What should we be doing?

    PERFORMANCE MANAGEMENT PLATFORM PLATFORM SERVICES

    Metrics Management

    Dashboarding

    Query & Reporting

    Analysis

    Event Management

    Planning

    Portal

    Security

    Configuration

    Administration

    Information & Business Modeling

    Data Integration

    Operational or Star Schema

    OLAP

    Enterprise Applications

    Flat, Modern and Legacy

    Cognos 8 BI - Introduction
    Cognos 8 BI is a complete enterprise business intelligence software solution with integrated reporting, analysis, scorecarding, and event management capabilities.

    Examine the Studios in Cognos 8 BI


    Metric Studio helps you manage the performance of your organization by monitoring and analyzing metrics at all levels. Query Studio helps you quickly answer a focused question.

    Analysis Studio performs simple to complex analyses and comparisons of data to discover trends, risks, and opportunities.
    Report Studio builds sophisticated reports, including multi-page, multiple-query reports against multiple data sources. Event Studio notifies users of key operational or performance-related events that may affect their business.

    Overview of Cognos 8 BI Features


    Cognos 8 BI features include:

    open data access integrated enterprise planning and consolidation dimensional reporting and dashboarding deep, large data comparative analysis extended self-service reporting process integration and Event Lifecycle Management actionable scorecards in Metric Studio extended data transformation services in Data Manager integrated portal

    Review Open Data Access

    Query Studio

    Report Studio

    Cognos Viewer

    Analysis Studio

    Event Studio

    Metric Studio

    Data Access

    SQL

    XML

    MDX

    ODBC

    Relational

    Files

    Composite Cubes

    Metric Database

    More

    Work with PowerCube Data in Cognos 8 BI


    You can work with your PowerCube data in all the studios in Cognos 8 BI.
    Query Studio Report Studio Cognos Viewer Analysis Studio Event Studio Metric Studio

    Data Access

    Cognos PowerCube

    Analyze Data From Multiple Data Sources


    Use Analysis Studio to analyze data in dimensional data sources (for example, PowerCubes, MSAS, and SAP BW) or relational data sources that are modeled dimensionally.

    OLAP data source

    Relational data modeled dimensionally

    What is Dimensionally Modeled Relational Metadata?


    Dimensionally modeled relational data is data you take from a relational data source and model as a star schema.

    Query OLAP Data Sources


    Multidimensional Expression (MDX) is the language used to query OLAP data sources.
    Original report

    Generated MDX

    Access Enterprise Planning (EP) Data Sources

    Query Studio

    Report Studio

    Cognos Viewer

    Analysis Studio

    Event Studio

    Metric Studio

    Data Access

    MDX

    SQL

    MDX

    SQL

    Views Publish Tables MSAS Published mart

    Metric Database

    Cognos Contributor

    Cognos Analyst

    Controller

    Identify Data Source Types in the Studios


    Relational model Dimensional model

    Demo 1
    Navigate Data in Different Studios

    Use Deep, Large Data Comparative Analysis


    Data in cubes can contain vast amounts of records making an analysis very large.

    Design Informative Executive Dashboards


    You can design informative dashboards using the extensive capabilities of Report Studio.

    Perform Self-Service Reporting


    Cognos 8 BI provides extended formatting, filtering, and calculations for ad hoc reports.

    Highlight Exceptional Data

    Perform Self-Service Reporting (contd)


    Cognos Office Connection extends the reach of the Cognos BI value to business users who prefer to work with Microsoft Office.

    Import a Cognos Connection report into Microsoft Office Excel using Cognos Office Connection.

    Manage an Event Lifecycle


    Notify users of key operational or performance events which impact the business.

    Examine Integrated Metrics


    Metric Studio is fully integrated into Cognos 8 BI.

    Extended Data Transformation Services in Data Manager


    The Data Manager engine is based on the Cognos 8 BI architecture:

    query subject data access (designed using Framework Manager) same data type support Unicode support

    Portal Integration and Subscription

    Summary
    In this module, we have:

    reviewed Corporate Performance Management introduced Cognos 8 BI examined the different studios in Cognos 8 BI identified the different data sources within the studios highlighted key capabilities of Cognos 8 BI

    You might also like