Calculation Manager: Enable Parallel Execution - Bug and Trick

When creating new Ruleset Designer there is an option to execute rules in parallel as given in the following screenshot.

However, as soon as you add / assign Rules under this ruleset, it disappears.

Note that this option is only available when the ruleset is selected and not the individual rule. So, you need to select / click on the ruleset to get this feature.

I believe this to be as a bug however there are at least two ways to get this option back.

• Save and close the ruleset and reopen.
• Another option is go to another tab in workspace and come back to this ruleset and you will see the option visible / enabled.

Job Console Entries...

Job console data is stored in table “HPS_JOB_STATUS” and when planning is restarted this data is cleared. After some research I finally found the details from here.

There is a property which can be set to never clear / delete these details or clear / delete periodically.

Property Name: JOB_STATUS_MAX_AGE

Value: 60000 (1000*60 for 1 minute – this is value in milliseconds)

Value: -1 (setting -1 will never clear / delete the data)

To set the property:

1.       Select Administration, then Application, then Properties.

2.       Select Application Properties to set properties and values for a Planning application.

3.       Add the property by clicking Add, entering the property in the blank row, and entering a value in Property Value

Reference / More Info:

1. http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin/frameset.htm?properts.html

2. https://community.oracle.com/thread/2516103?tstart=0

Calculation Manager Business rule / Script validation issue

Business rule / Script not getting validated when line of code exceeds certain number

We have a calculation manager business rule that calls a script which calls a template around 22 times by passing different entity values. When we compiled the business rule it threw the following error:

A validation error was received from the Planning server 'http://<URL>:80/HyperionPlanning/servlet/HspAppManagerServlet?appname=<appname>'.

'Error:Error parsing formula for [<member name>] (line 5106): infinite loop in macro processing; current macro [@VAL] Rule <Rule Name>'.

On analysis, it is observed that when we made less than or equal to calls (17 – where line of code is less that 5000) to the template then it successfully compiled. In short, any further calls (more than 17 – i.e when line of code is probably greater than 5000) to the script system failed to compile.

To confirm where this is the issue with number of line, I created a rule with entire logic written as part of single script which had more than 5000+ lines. Again this time the system failed to validate and gave the same error.