COGNOS INSTALLATION

Click Add or Remove Programs , Click Add / Remove Windows Components, Select Internet Information Services, Click Next Button, Click Next Button, Click Finish to Complete IIS Installation.

Install SQL SERVER 2005, Login to SQL, Login: sa, Password: sa / 123, Click Connect,Click Finish to Complete SQL 2005 SERVER.   
Open COGNOS 8.4 Folder, Open COGONS 8 BI Server 8.4, Open Win32 Folder, Click Setup. 


Select English, Click Next, Select I accept button, Click Next, Select Installation directory, Click Yes, Click Next, Enable Cognos Content Database, Click Next, Click Next, Click Ok, Click Finsh. 

Open Cognos 8.4 Folder, Copy samples Folder, Past in C:\Program Files\cognos\c8\webcontent  
Now you can log-in and use cognos.
Getting Started with Cognos ? ?

  • Cognos 8 BI applications overview

     Cognos is a webbased reporting tool. Which is developed by IBM. For generating the reports using the existing database.We have in Cognos Framwork Manager, Cognos Connection, Query Studio, Analysis Studio, Report Studio, Event Studio, Drill Through Definitions and IBM Cognos Administration.


Cognos BI 8 components


  • Query Studio - a tool used for creating basic ad-hoc reports and a lighter version of Report Studio. It allows users to create one 1-page report at a time. Application used by Query Authors and Report Authors.
  • Report Studio - used to create and manage more advanced reports, which are very often standarized and executed periodically and distributed to people in various departments in an organization. Reports can engage dashboards with gauges, charts, maps and other graphical elements with a full drill-through capabilities. Reports designs created in Query Studio can be read and edited in Report Studio (and not the opposite way). Report Studio is used by Report Authors. 



  • Analysis Studio - an application to analyze OLAP cubes and explore business data in a multidimensional manner. Large volumes of data can be analyzed through ranking, complex filtering, slicing, dicing and creating custom subsets. Mainly used by business analysts.
  • Metrics Studio - used for scorecarding, helps manage performance by monitoring and analyzing metrics at all levels of an organization. The idea behind it is to put performance indicators next to the organization's key performance measures (red, orange, green status notation) and link them to reports containing related information.
  • Event Studio - a process (an agent) which runs in background and monitors the data and reacts when something ocurrs which may cause a business problem in the future. For instance, if quantity of a product X on stock is less than a given value, event manager can send an email to a responsible person which will contain a warning with the problem description and a link to a cognos report.
    Event studio takes such actions as: generating emails, running reports, updating news channel in a corporate portal or communicating with other software.
    Aside from tracking actual products, it can also be used to monitor services. For example if the number of subscribers in, say, a mobile broadband service exceeds the set capacity, event manager can email the necessary people so the problem could be looked into.
  • Cognos Connection - it is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization's business intelligence data.
  • PowerPlay Transformer and PowerPlay (Cognos 8 Business Intelligence Mobile Analysis ) - The Cognos 8 BI Mobile Analysis package is a new name for Cognos 7 PowerPlay applications. In fact, apart from the integration with Cognos 8 packages, there are no major changes since PowerPlay version 7.
    Among others, the package includes the following applications known from Cognos 7 BI:
    - Cognos PowerPlay Series 7 Version 4
    - PowerPlay Connect
    - PowerPlay for Excel
    - Configuration Manager
    - Cognos Scheduler
  • Content Store is a database where the metadata for all the Cognos 8 component is stored and managed centrally.
    Content store can be accessed directly with the Framework Manager.
  • Framework Manager is a Cognos 8 modeling tool for creating and managing business-related metadata for use in all Cognos 8 BI applications. It lets modelers model relational data dimensionally, apply hierarchies to allow drill behavior, apply member functions and query any of the supported data sources (relational database with SQL or OLAP with MDX).
    The main users of Framework manager are data warehouse developers and data modelers. Report authors base on the metadata information set up using Framework Manager when creating new reports.


  • Cognos Series 7 and IBM Cognos 8 BI products comparison

    Cognos 8 is a completely different product than Cognos 7


    Cognos series 7
    • Cognos PowerPlay
    • Cognos PowerPlay Web
    • PowerPlay Excel
    • Impromptu
    • Cognos WebPortal
    • Visualizer
    • DecisionStream
    • PowerPlay Transformer / Impromptu Administrator
    • Metrics Manager
    • Notice cast
    • Planning
    IBM Cognos 8 BI
    • BI Mobile Analysis (PowerPlay)
    • Analysis Studio
    • IBM Cognos 8 BI Analysis for Microsoft Excel
    • ReportNet (Report Studio + Query Studio)
    • Cognos Connection
    • GO! Dashboard / Report Studio
    • Data Manager
    • Framework Manager
    • Metrics Studio
    • Event Studio
    • Planning


    Cognos Certification Exam


    COG-612 : IBM Certified Cognos 8 BI Report Auther exam



    Level I – Run Existing Reports

    Login to Cognos Connection

    Tour of Cognos Connection

    Run in browser

    Run with Options

    Download to Excel

    Email a report

    Schedule a report

    Schedule a recurring report

    My Area

    Other Actions



    Level II – Basic Report Writing

    List Reports
           
    Login to Report Studio and choose package

    Five main components of Report Studio

    A1.  Add fields

    A2.  Use pre-written prompts

    A3. -A5. Add filters

    A7.  Save in My Folders

    B1.  Rename / Save as

    B2.  Remove fields

    B3.  Sort

    B4.  Change column order

    B5.  Group

    B7.  Add an Aggregate for subtotals and totals

    B9.  Add row numbers

    B10. Format a number for number of decimal points

    B11. Change date/time format

    B12. Add a calculated field for percentage

    B13. Create report title

    B14. Create dynamic title

    B15. Add text to footer

    B16. Download to Excel

    B17. Create a prompt

             
    Crosstab reports
    Areas of a Crosstab report         

    A1.  Add fields

    A2.  Sort fields

    A3.  Use Pre-written prompts

    A5.  Add filters

    A6.  Format numbers for decimal points

    A9.  Swap rows and columns

    A10. Add totals

    A11  Change names of row and column

    B.  Change a List report into a Crosstab report

    C.  Create Drill Through















    Repeater tables

    Repeater Table defined

    1. Convert a List report to a Repeater Table

    2. Create a Repeater Table from scratch

    2. l.  Add a simple prompt

    2. m. Add a border to a Repeater

    3. Add a Repeater Table to a List

           
    Charts

    A. Chart Groups and Types

    B. Pie Chart

    C. Column Chart added to a Crosstab report

    D. Convert a chart to a different type


    Prompts

    A. Add a pre-written prompt

    B. Add a simple prompt with a filter Expression

    C. Add a Text Box Prompt

    D. Add a Value Prompt

    E. Create a Cascading Prompt page


    Advanced Topics

    Joins using Query Explorer

        A. Simple report, starting with List

           Run menu item / View Tabular Data

           Join Relationship / Cardinality

           Adding a Query Calculation

           BONUS - Add another field to the report

           BONUS - Add another report to verify your data

        B. Join with different queries

    Master-Detail

         BONUS – Master-Detail with Drill Through

    Report Templates

        Header/Footers

        Borders

    Conditional Formatting

        Exceptional Data – Conditional Styles button

        Alternating color on rows – Condition Explorer


    Expressions

    1-7.General Information

    8. IF-THEN-ELSE and CASE WHEN

    9. Function tab to help write expressions

    10. Warning about Auto-aggregate feature


    Complex Report

    Join

    GL Dept Detail Tree

    Expression

    Repeater

    Master/Detail


    Tips & Hints

    1.  URLs for Cognos

    2.  Join Cognos mail list

    3.  Email for questions/problems

    4.  Two ways to run reports

    5.  Unrecognized SOAP error

    6.  Delete vs. Cut

    7.  Singleton data element and how to avoid

    9.  Hints for Filters / Writing Expressions

    10. Validate Report

    11. Write report in DEV and copy to PROD

    12. Write report in DEV/PROD and copy to same DB

    13. Two ways to open report in Report Studio

    14. Sort – how to view or change sort order in List

    15. Use My Area/My Preferences - customize the “look”

    16. No Data Content option

    17. Browser will show when report needs to be saved

    18. More about Filter Expressions

    19. Crosstabs – adding rows, columns, measures

    20. Pickup Style/Apply Style to copy text formatting

    21. IF THEN ELSE expression