my daily dashboard reads from let say 20 datasets.
One of this 20 datasets is huge and refreshed once a month.
Therefore I would like my dashboard, during its daily refresh, to go through the script as always and skip the load part of this huge dataset, if we are not in the first friday of the month....but it should also keep the values somehow, otherwise when the dashboard is refreshed, the values in that huge dataset are not visible (for a month...)
I hope I made it clearer!
Well thats tricky.
A simple option that i can think of is.. (I cannot call this a solution) But anyways..
First, after you read the dataset that is huge and if you do some calculation on top of it... i suggest you then store that table into a QVD at some location.
Next, you can then use a script like below.
Let vToday = WeekDay(Today());
If $(vToday) = 'Fri' then
Run my script to load the latest data...
Load the data from my QVD
With this approach you can at least have the reload time reduced during the other six days in the week and you would have the laod time increased only for four days in thee month.
hope this helps.
that would indeed be a great trcick, but sadly the dataset I am loading it is already a QVD (QVX actually) ..
I did that some time ago to already reduce load time.
Now I wanted to reduce once more reload time, as the whole dashboard is getting big, and I thought "what's the purpose of refreshing daily data which is actually refreshed MONTHLY at the source"..
So I was hoping it would have been an easy tweak, to have QV keep data from previous session and skip that part of the script..