MDX-Calculation is very slow by browsing

  • 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 get 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:

  • Replace the order of EXISTING and NONEMPTY and you should see an improvement.
    The appliance of the NONEMPTY will eliminate the NULLs and then the EXISTING will have to check from a smaller set (in your case maybe extremely smaller).

    Igor Micev,My blog: www.igormicev.com

  • Great ! this helps .. Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply