Cognos Analytics

Hello, my name's Leonardo Machado and I'm a college student from Brazil.
I'm using Cognos Analytics free trial for students to make a college project about Organ Donation.

My group's ideia is to use Cognos for a real-time monitoring dashboard that will display data like 'how many organs were transplanted today' comparing this data to the past days. The data won't be real, we will create samples in excel or oracle SQL Developer to make a simulation.

The problem is: we don't know how to make cognos automatically refresh the data from the database or from a system local file. The only way we found to refresh was by clicking 'Replace File' and selecting it, which not helps.

Can anyone give us a hint? A video or a tutorial would be VERY helpful!

Thanks!




------------------------------
Leonardo Machado de Andrade
------------------------------

#CognosAnalyticswithWatson

Original Message:
Sent: 5/28/2020 7:54:00 PM
From: Leonardo Machado de Andrade
Subject: Help with Real-Time Monitoring

Hello, my name's Leonardo Machado and I'm a college student from Brazil.
I'm using Cognos Analytics free trial for students to make a college project about Organ Donation.

My group's ideia is to use Cognos for a real-time monitoring dashboard that will display data like 'how many organs were transplanted today' comparing this data to the past days. The data won't be real, we will create samples in excel or oracle SQL Developer to make a simulation.

The problem is: we don't know how to make cognos automatically refresh the data from the database or from a system local file. The only way we found to refresh was by clicking 'Replace File' and selecting it, which not helps.

Can anyone give us a hint? A video or a tutorial would be VERY helpful!

Thanks!




------------------------------
Leonardo Machado de Andrade
------------------------------

#CognosAnalyticswithWatson

Hi Leonardo, here is a quick tutorial for this: Set a timed data refresh (11.0.4+)

------------------------------
Ahmed Abdel-Baky
------------------------------

Original Message:
Sent: Thu May 28, 2020 07:54 PM
From: Leonardo Machado de Andrade
Subject: Help with Real-Time Monitoring

Hello, my name's Leonardo Machado and I'm a college student from Brazil.
I'm using Cognos Analytics free trial for students to make a college project about Organ Donation.

My group's ideia is to use Cognos for a real-time monitoring dashboard that will display data like 'how many organs were transplanted today' comparing this data to the past days. The data won't be real, we will create samples in excel or oracle SQL Developer to make a simulation.

The problem is: we don't know how to make cognos automatically refresh the data from the database or from a system local file. The only way we found to refresh was by clicking 'Replace File' and selecting it, which not helps.

Can anyone give us a hint? A video or a tutorial would be VERY helpful!

Thanks!




------------------------------
Leonardo Machado de Andrade
------------------------------

#CognosAnalyticswithWatson

Hi Leonardo,

If you are using a database as your source then you will get latest data but if you are using excel files as a source then there is not inbuilt functionality to schedule excel data but you can do it with Jupiter notebook ​if you have it installed on Cognos.

Thanks
Hemal

------------------------------
Hemal Patel
------------------------------

Original Message:
Sent: Thu May 28, 2020 07:54 PM
From: Leonardo Machado de Andrade
Subject: Help with Real-Time Monitoring

Hello, my name's Leonardo Machado and I'm a college student from Brazil.
I'm using Cognos Analytics free trial for students to make a college project about Organ Donation.

My group's ideia is to use Cognos for a real-time monitoring dashboard that will display data like 'how many organs were transplanted today' comparing this data to the past days. The data won't be real, we will create samples in excel or oracle SQL Developer to make a simulation.

The problem is: we don't know how to make cognos automatically refresh the data from the database or from a system local file. The only way we found to refresh was by clicking 'Replace File' and selecting it, which not helps.

Can anyone give us a hint? A video or a tutorial would be VERY helpful!

Thanks!




------------------------------
Leonardo Machado de Andrade
------------------------------

#CognosAnalyticswithWatson