Improve Performance of Xcelsius Dashboard built using WEBI using Live Offic
Please let me know how to improve the performance of the Xcelsius Dashboard built using WebI Report using Live Office.
In the excel, the Refresh option option has been set with Refresh on Demand.
And there are 4 Live Office connections in the dashbaord and only one connection is set to Refresh on Load.
The WebI Report executes within a sec but the Dashboard takes quite a long time to execute.
Also, I am using XY Chart and it takes more tme to execute.
Please let me know if there is a way to increase the performance.