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