In this blog, we will have a look at Scripts which were called automators in some earlier versions. Scripts in Oracle Hyperion DRM (Data Relationship Manager) are a simple tool that execute sets of simple instructions in one bulk load. For example, if you need to change the value of one property against hundreds of nodes, the simplest way to do this is to create a Script. An effective way to increase productivity through the use of automation.
The basic rule in a script is that each line is a specific action. Each line also needs to be divided into columns by a delimiter. The first column should contain the action code. Oracle Hyerion DRM supports an important list of action codes that allow you to carry out a lot of different actions such as change property (“ChangeProp”), add a node (“Add”), insert a node (“Insert”), remove a node (“Remove”) and so on. The full list of actions available is described in the Oracle Hyperion DRM user guide. The following columns will contain the parameters for the action.
As an example in this blog, I am going to add a node into a hierarchy then change its description. This will require two actions and my Script will need two lines:
- First add the node using the “Add” action code. This code takes 5 parameters:
- Version – This is the name of the version in which the node will be added.
- Hierarchy – Name of the hierarchy in which the node will be added.
- Node Name – Name of the node to be added.
- Parent name – Name of the parent of the node.
- Leaf – Flag indicating if the node is a limb or a leaf.
- In the second line we use the action code “ChangeProp” to modify the description. This action also takes 5 parameters:
- Node Name
- Property – Name of the property to be modified.
- Value – New property value.
So the file looks like this:
You can build this file using a simple text editor or Excel. In Excel, just save the script as a .csv file.
To execute the Script, navigate in Oracle Hyperion DRM to the Script section.
Specify the file characteristics like the column order, the column delimiter or the encoding in the “Source” section. Then browse to your file and press “Load”. Once the file is loaded, you will see the list of actions Oracle Hyperion DRM has recognized in the bottom section. Any action code that was not recognized will be ignored.
In the menu called “Script” there are some additional options. For example, you can substitute the versions in the Script for a different version present in Oracle Hyperion DRM. You can also select only a subset of lines you which to execute. Once you are ready, press the play button. This will execute all the selected lines.
Once the Script has been executed, you can see the result in the “Status” and “Return Value” columns.
“Status” will flag any error and “Return Value” will return the error message if there was an error or any other return value depending on the action code. These results can be saved by navigating into the Script menu then selecting download then the format.
While this was a simple example we hope that it was clear and useful. If you have any questions you know where we are and we would be delighted to help.