I need to create Dashboards using data which can only be downloaded manually as a CSV. Now, i can create Data CUbes using the CSV file and create the dashboards.
But, I need to update the dashboards each quarter by downloading the latest CSV from the source.
I there a way that Dundas can pick the downloaded CSV from a fixed location every month and auto-update the Data Cube?
If that’s not possible, can I just drop the latest downloaded CSV onto the datacube and the Cube updates itself?