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.I...
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.Please ...
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