Creating Java Application Control Language (JACL) Scripts
Purpose
This tutorial covers how to create JACL scripts.
Time to Complete
Approximately 20 minutes.
Overview
Script files contain commands to execute a workflow. Integrated Operational Planning uses script files to build models and to configure business processes.
For example, you can use JACL files to invoke java classes on server startup, and java script files to customize a model or reports.
JACL scripts intermix isadmin commands with other activities such as polling external data sources, sending e-mails, extracting data, calling APIs, and integrating with other systems. When the server starts, it prepares the script execution environment, and it is ready to accept JACL scripts.
Scenario
In this example, you create a JACL script to publish dimensions and cubes.
Software and Hardware Requirements
The following is a list of software requirements:
- Integrated Operational Planning 4.0.1
- Java Development Kit JDK 1.6.0_12 or later
- Microsoft Internet Explorer 6.x or 7.x
- Oracle 10.2.0.4 or 11.1.0.7 database
Prerequisites
Before starting this tutorial, you should:
| . | Load the Integrated Operational Planning model. |
|---|---|
| . | Start the Integrated Operational Planning server. |
| . | Define Integrated Operational Planning dimensions, row sources, and cubes. |
Creating JACL Scripts
To create a JACL script, perform the following steps:
1. |
Log on to Integrated Operational Planning as the administrator.
|
|---|---|
2. |
From Planning Workbench, click the Administration Workbench link.
|
3. |
Select the Administration tab.
|
4. |
Select the Script Editor tab.
|
5. |
Click Add to display the Create script file page.
|
6. |
In the Name box, enter the name of the JACL script. In this example, enter Publish_dimension_cube.
|
7. |
From the Type drop-down list, select Jacl script. When you create a file, you must select a file type. In this example, the file will be saved on the Integrated Operational Planning server as Publish_dimension_cube.jacl. Script files are stored in /install/custom/scripting.
|
8. |
In Contents, enter the script syntax. In this example, the syntax specifies that dimensions and cubes are published, in that order.
|
9. |
Click OK.
The script is displayed on the Script Editor page.
|
In this tutorial, you learned how to create JACL scripts.
Resources
- Oracle Integrated Operational Planning Release 4.0.1 User's Guide
- To learn more about
Integrated Operational Planning, refer to additional OBEs and the Modeling in Integrated Operational Planning tutorial on the Oracle Technology Network Web site.
