COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: anandcognos on 02 Apr 2020 08:39:31 AM

Title: Way to refresh uploaded excel in Cognos Analytics ?
Post by: anandcognos on 02 Apr 2020 08:39:31 AM
Hello

We are using visitdata.xlsx file as a data source for dashboard in cognos analytics. Excel file in server location from where it was uploaded in cognos was updated successfully, but uploaded excel in cognos was not refreshed. Is there any way through which uploaded excel in cognos get refreshed automatically? If not, please suggest me if fetching data from tables is the only way to get refreshed data in a dashboard ? I am sharing a image displaying visitdata.xlsx uploaded in Mycontent in cognos analytic. Please pour in your ideas, I will appreciate any sort of help.

Thanks,
Anand
Title: Re: Way to refresh uploaded excel in Cognos Analytics ?
Post by: MFGF on 06 Apr 2020 10:19:49 AM
Quote from: anandcognos on 02 Apr 2020 08:39:31 AM
Hello

We are using visitdata.xlsx file as a data source for dashboard in cognos analytics. Excel file in server location from where it was uploaded in cognos was updated successfully, but uploaded excel in cognos was not refreshed. Is there any way through which uploaded excel in cognos get refreshed automatically? If not, please suggest me if fetching data from tables is the only way to get refreshed data in a dashboard ? I am sharing a image displaying visitdata.xlsx uploaded in Mycontent in cognos analytic. Please pour in your ideas, I will appreciate any sort of help.

Thanks,
Anand

Hi,

There was a long discussion on this topic here:

https://www.cognoise.com/index.php/topic,34938.0.html

The short answer is no - you can't schedule file uploads currently.

Cheers!

MF.