Performance of Slice vs ISB vs Active Form vs Cube Viewer
Posted: Fri Oct 11, 2013 4:17 am
Ok, so we're running TM1 9.5.2 Perspectives, and had noticed many users having issues with refreshing slices - when testing the same view via different interfaces we found :
a. Cube Viewer = OK
b. Inspreadsheet Browser = OK
c. Active Form = slightly slower, but still OK
d. Excel Slice = really slow and/or the file hangs/crashes Excel
e. (we don't use TM1 Web)
So my questions are :
1. What is the difference in method for the way Slices extracts data from the server vs other methods above?
2. What are some possible causes/resolutions for the Slice performance issue? (e.g. streamline the user's XL formulas, check for security patches on the PC etc...)
muchas gracias!
Matt
a. Cube Viewer = OK
b. Inspreadsheet Browser = OK
c. Active Form = slightly slower, but still OK
d. Excel Slice = really slow and/or the file hangs/crashes Excel
e. (we don't use TM1 Web)
So my questions are :
1. What is the difference in method for the way Slices extracts data from the server vs other methods above?
2. What are some possible causes/resolutions for the Slice performance issue? (e.g. streamline the user's XL formulas, check for security patches on the PC etc...)
muchas gracias!
Matt