Planning Analytics

 View Only

PAfE highly customised Dynamic Reports Performance

  • 1.  PAfE highly customised Dynamic Reports Performance

    Posted Thu June 17, 2021 10:57 AM
    Hello everyone,

    we have large dynamic reports (2400 x 60) with calculated columns referencing multiple cubes. In PAfE their performance now is abysmal in comparison to Perspectives. Building the Report now takes 3x (~3min) as long when expanding all levels. We expand all levels, by updating the underlying MDX.

    Is there some way to figure out where we are losing the performance or are there some general guidelines as to how increase report performance?

    I am looking forward to your response.

    ------------------------------
    Constantin Budin
    ------------------------------

    #PlanningAnalyticswithWatson