Importing Essbase Calc Scripts as Graphical Business Rules

You can import Oracle Essbase calc scripts into Oracle Hyperion Calculation Manager as graphical business rules.

When you import an Essbase calc script that contains a SET RUNTIMESUBVARS calculation command, all of the Essbase runtime substitution variables (preceded by an ampersand character in the script) are converted to Calculation Manager runtime prompt variables with {} notation. By default, a variable string is created in Calculation Manager using the value of the variables from the RUNTIMESUBVARS command of the Essbase calc script. For more information on creating these calc scripts in Essbase, see the Oracle Essbase Database Administrator's Guide.

In Calculation Manager, the variable's value is displayed in the Value column of the Variables tab when you open the business rule in the Rule Designer. (You can see the variable's default value by opening it in the Variable Designer and looking at the Default Value column.) However, if the calc script variable does not have a value or default value, then Calculation Manager does not display any values.

If there is any text between the <RTSV_HINT> and </RTSV_HINT> tags in the calc script, that text is used as runtime prompt text for the variable; if there is no text between these tags, the prompt text is the name of the variable.

To import an Essbase calc script as a graphical business rule:

In System View, right-click the database, and then select Import Essbase Calc Script.

This menu option is only available if there are Essbase calc scripts to import.
For each calc script, select whether it already exists in Calculation Manager and whether you want to import it. (To import all calc scripts, click Select All.)
Select one of these options: .
- Select Override Existing Objects to replace existing objects with new objects of the same name.
- Select Skip Existing Objects to keep existing objects when new objects have the same name.
Click Import.

Note:

If the imported calc script is imported as a script component, there may be a parsing error. Validate the rule, and if there is a parsing error, do either of the following to fix it. 1) Fix the parsing error in Calculation Manager, validate the rule, right-click the script component and select Convert to Graphical, and save the rule. (To undo the conversion to graphical, select Edit and then Undo Convert.) 2) Open the original calc script, fix the parsing error, save the calc script, and import the calc script into Calculation Manager again. The calc script has a check under Already Exists. Select the Import check box and Overwrite Existing Objects.

After you import calc scripts, if the imported calc script is in a script component, and you want to view it in graphical format, right-click the script component in the rule flow chart, and select Convert to Graphical.

You can also save the results of the import to a local file.