Cognos Analytics

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
------------------------------

Original Message:
Sent: 2/21/2021 7:58:00 AM
From: Alexandre Lanoue
Subject: Question: Building a dashboard - How to display objectives & compare to them?

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
------------------------------

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
------------------------------

Original Message:
Sent: Sun February 21, 2021 07:58 AM
From: Alexandre Lanoue
Subject: Question: Building a dashboard - How to display objectives & compare to them?

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
------------------------------