I have a workbook with multiple queries. It gets executed automatically with the help of precalculation server and goes to the portal daily for multiple sales category.
The problem is that the data is some of the queries are not getting refreshed.
Only after changing the Data Providers and excuting them individually, the data is coming properly, but this is a tedious job.
Please tell me how do i get the current data using the precalculation server. Or is there any other way?