Pass Planning Calc Manager variable run time prompt values to an Essbase Partition

I had a requirement to pass planning calc manager variable run time prompt values to an Essbase Partition to refresh a partition for a specific scenario and version. We know we can run a MaxL file from a planning business rule using CDF. Can we extend this further and pass on run time prompt values to the MaxL file as well so they can be used in a partition definition? Say for example that we … Read More

Using Planning Calc Manager Variables in Essbase Calculation script with SET RUNTIMESUBVARS command

On a recent project, I wanted to execute an Essbase Calc script with substitution variables set to accept values passed by Planning business rule run time prompts. In this specific case, I wanted a user to run a business rule in a planning application that would use the run time prompt values and pass on to a calculation script in a separate standalone Essbase database. I used a combination of CDF in business rule that … Read More

How to fix Calc Manager Business Rule error: Business Rule execution time has exceeded the maximum configured wait time. Business Rule will now be executed in the background.

By default, Business rules wait until 3 minutes (180000 milliseconds) before moving the execution to the background. When the wait time threshold is reached the user gets the following warning/error message: Business Rule execution time has exceeded the maximum configured wait time. Business Rule will now be executed in the background. To check Business Rule execution status, open the Job Console Page. This is inconvenient especially when users do not get to know if a … Read More