Post reply

MDX-Calculation is very slow by browsing

  • March 31, 2017 at 12:26 am

    #336688

    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:

  • March 31, 2017 at 1:50 am

    #1935912

    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

  • March 31, 2017 at 3:36 am

    #1935929

    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