I have Cubeview which takes ~50 secs to refresh in OS. When I insert
same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes
over 2 mins. It is simple insert and refresh i.e. I do not have anything
additional like VBA code etc in Excel...
CubeView - Calculate the Variance for multiple columns (
Column-by-Column) Hi there, I am trying to calculate variance
Column-by-Column for all time members of Current Year Vs. Prior year and
looking for good option for performance optimization. Plea...
Thank you Bob. Great suggestion for troubleshooting. I tired and indeed
the refresh time reduces to 1 mins 20 secs (down from 2 mins 20 secs).
One step closer...I believe next step is to diagnose what is slowing in