Cognos Analytics

Expand all | Collapse all

Question: Building a dashboard - How to display objectives & compare to them?

  • 1.  Question: Building a dashboard - How to display objectives & compare to them?

    Posted 4 days ago
    Hi,

    I have been looking for the best way to achieve the following in Cognos Analytics for a while now. How do you build a report where you can display KPI and compare the actual to the result?

    I am looking for a way to reproduce what my team is currently doing in an Excel spreadsheet. My objectives are defined by management in a spreadsheet and the results come from the transactional system. Two questions:
    1. What is the best way to structure the objective sheet so we can link them to the results?
    2. How do you create a table that will present the information?

    Thanks!

    Alex

    ------------------------------
    Alexandre Lanoue
    Executive & Leader - Enterprise Advisory Services
    SIA Innovations Inc.
    Montreal QC
    5148425764
    ------------------------------


  • 2.  RE: Question: Building a dashboard - How to display objectives & compare to them?

    Posted 3 days ago

    Alexandre Lanoue – I believe you can use the KPI visual in Dashboard.  It will allow you to enter in the Base value, Target value and the Time dimension.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 3.  RE: Question: Building a dashboard - How to display objectives & compare to them?

    Posted 3 days ago
    Hi @Alexandre Lanoue,
    I think any good approach is based on data modules where you can join (or union) an uploaded spreadsheet easily with your transactional data. ​The transactional data may be accessed directly from a data source, as (usually aggregated & compressed) data sets or by a (usually rather complex) Framework Manager model. 
    Best, 
    Philipp

    ------------------------------
    Philipp Hornung
    ------------------------------