SQLTeam.com | Weblogs | Forums

MDX-Calculation is very slow by browsing


#1

Hi,
i have only this Code as Caluculation in my Cube.sln.
By opening Cube-Browser and when i browse the Cube at this SCOPE it takes very long Time Data are displayed.
Is ther any Option, to optimize the Performance ?

-- The Code g‌et allways the last Value on Hierachie-Level to the Total.

‌SCOPE([Measures].[Anzahl Server],[Time - DayLevel].[CalendarYear - Hierarchie].Members );
THIS = TAIL ( NONEMPTY ( { EXISTING [Time - DayLevel].[CalendarYear - Hierarchie].Members } ),1).ITEM(0);
END SCOPE;

Best Regards
Nicole
:ermm:‌‌