In that document, you have a command line script you have to execute after the reload of the new data and prior to the access by the users. Using Windows Task Scheduler will do.
What you need to do is to define is the click script which will better serve the purpose of cache warming given that:
- Not all possible combinations are possible (it would take too long)
- There are some VIP users which will have priority
For scenario 1 create this click script using the script generator GUI included in the Scalability Tools. Actions such as Activate all Sheets, make "default" selections if there are any (e.g.: select current month), activate heavier charts or make selections on more populated sheets will always help.
For the second, create a list of users as if they were in the section access (if there is already section access in the document you will need that anyway). The idea is that during the time it takes to perform the script, the server is going to be utilized very, very heavily, so the entire script has to be short (depending on your users and reloads, I would say no longer than 15-20 minutes).
I'm still getting accustomed to the new Community, bear with while I retrieve links I had bookmarked for the previous.
.png "Miguel_Angel_Baeyens"){kind=avatar}
