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

    Essbase calc not working [PBCS]


      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:



      "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,