2.For the first connection in chain set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the input from the user, say It is Company Name and Brand Name and your are using Filter component to ask the values from user.
3.Select “When Cell Updates” option.
4.Set “Loading Message” to “x” (Value which you will never user)
5.Set “Idle Message” to 1 and insert it into a cell say “D2”, as shown in below image
6.Now, set the Usage Options for the 2nd Live Office connection (Live2). Set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the “Idle Message” of the Live Office connection1 (Live1)
7.Select “When Value Equals” option and enter the value which you inserted in Idle Message of connection Live1. In this case it is 1
8.Set “Loading Message” to “x” (Value which you will never user)
9.Set “Idle Message” to 2 and insert it into a cell say “D3”, as shown in below image
10.Now, set the Usage Options for the 3rd Live Office connection (Live3). Set “Refresh on Trigger-> Refresh Cell” to the cell where you are storing the “Idle Message” of the Live Office connection2 (Live2)
11.Select “When Value Equals” option and enter the value which you inserted in Idle Message of connection Live2. In this case it is 2
12.Set “Loading Message” to “x” (Value which you will never user)
13.Set “Idle Message” to 3 and insert it into a cell say “D4”, as shown in below image
Same steps can be repeated for as many connections as you want. I have used 8 live office connection to refresh with same logic.
Your screen shot has a Trigger Cell option called When Cell Updates. Our version doesn't show that option.
ReplyDeleteAlso seems that our data connection goes into an idle state while it's waiting for the data which in turn kicks off the next connection and so on and so on etc.. So in short order they are all trying to retrieve and the same time.
Am I missing something
Hi,
ReplyDeleteI am using Xcelsius 2008. As per my knowledge, idle message activates only after data is refreshed, still you check. If you are following the steps I have mentioned, then you are not missing anything.
Reagrds
Dear S Manocha,
ReplyDeleteBut if you make every report depending on each other by triggering when report is inactive then refreshing will not be simultaneously. or am i wrong?
I just create a one refresh button where a check all reports which need to be refresehd on load and they all start at the same time and they are running parrellel. So one report is earlier done then other but they run simultaneous. I tested with Fiddler. So please explain how your solution is working
You are right rjobaan, I had same problem. But it is only when dashboard loads. After that I am being able to control the simultaneous loading. If you have some problem, you can contact me on phone. Mail me at your email id at sandeepmanocha.hcl@gmail.com
ReplyDelete