4 Replies Latest reply on May 16, 2018 9:57 AM by AL.

    Essbase calc not working [PBCS]

    AL.

      Hello Experts,

       

      I'm building the following  BR:

      Is to calculate the Monthly % of some "dummies" accounts created on the hierarchy, and using the average of the % of its siblings:

       

      "Monthly"=@AVG(SKIPBOTH,@SIBLINGS(@CURRMBR("Account") ));

       

      It's calculating the values correctly but it's taking too long. So doing my own tests, I've tried opening budget block:

       

      Budget(

      "Monthly"=@AVG(SKIPBOTH,@SIBLINGS(@CURRMBR("Account") ));

      )

       

      It's executing really fast but doing nothing.

       

      Does anyone know why? (Scenario is sparse and Monthly a member from a dense dimension)

       

       

      Thanks in advance and Best Regards,