To connect and automate Oracle® Analytics Cloud (OAC) as part of a chain, add a step that includes an Oracle Analytics Cloud connection command. For example:
- Execute calculations
- Exchange and load data and commands to administer OAC
To enable these commands, an IT admin first creates an Oracle Analytics Cloud connector.
Build Dimension
To load dimensions to a cube, add a Build Dimension command.
Properties
Input |
Detail |
Application |
Enter the OAC application to load to. |
Database |
Enter the OAC database—or cube—to load to. |
Dimension File |
Enter the name of the dimension build file. The full path is unnecessary; files are assumed to be in the relevant application or database directory. |
Rules File |
Enter the name of the rules file. The full path is unnecessary; files are assumed to be in the relevant application or database directory. |
Restructure |
Select the preservation choice for the outline restructure. |
Force |
To force the dimension build without verifying the outline, check the box. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Calculation Script
To calculate a cube, add a Calculation Script command.
Properties
Input |
Detail |
Application |
Enter the OAC application. |
Database |
Enter the OAC database—or cube—to calculate. |
Script File |
Enter the name of the calculation script, with the .csc file extension. The full path is unnecessary; files are assumed to be in the relevant application or database directory. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Clear Data
To clear data from a cube, add a Clear Data command.
Properties
Input |
Detail |
Application |
Enter the OAC application to clear data in. |
Database |
Enter the OAC database—or cube—to clear data in. |
Option |
Select the keyword specifying what to clear. |
Region |
Enter the multidimensional expression (MDX) that specifies the region to clear. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Create Variable
To create a substitution variable defined at the application or cube scope, add a Create Variable command.
Properties
Input |
Detail |
Application |
Enter the OAC application to create the variable in. To create the variable at the cube scope, leave blank. |
Database |
Enter the database—or cube—to create the variable in. To create the variable at the application scope, leave blank. |
Name |
Enter the name of the variable to create. |
Value |
Enter the value of the variable to create. |
Outputs
Output |
Output Type |
Created Variable |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Delete File
To remove cube artifacts from the application, database, or user home directory, add a Delete File command.
Properties
Input |
Detail |
Application |
Enter the OAC application to delete from. |
Database |
Enter the OAC database—or cube—to delete from. |
File |
Enter the name of the file to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Delete Variable
To delete a substitution variable defined at the application or cube scope, add a Delete Variable command.
Properties
Input |
Detail |
Application |
Enter the OAC application to delete from. To delete a variable defined at the cube scope, leave blank. |
Database |
Enter the database—or cube—to delete from. To delete a variable defined at the application scope, leave blank. |
File |
Enter the name of the variable to delete. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Deploy
To create a cube from a Microsoft Excel® workbook, add a Deploy command.
Properties
Input |
Detail |
Application |
Enter the OAC application to create the cube in. |
Database |
Enter the name of the database—or cube—to create. |
Excel Workbook |
Enter the Excel workbook file to create the cube from. If referring to a file on the server, it must be in the user's directory. |
Execute Script |
To execute any calculation scripts included in the workbook, check this box. |
Create Files |
To create cube artifacts in the files directory on the cloud service instance, check this box. |
Recreate Application |
To recreate the application if it already exists, check this box. |
Load Data |
To load data from a workbook that contains a data worksheet, check this box. Otherwise, the command imports only metadata into the cube. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Download File
To download cube artifacts from an Essbase® instance to a local directory, add a Download File command.
Properties
Input |
Detail |
Application |
Enter the OAC application to download from. |
Database |
Enter the database—or cube—to download from. |
File |
Enter the name of the file to download. |
Auto-unzip |
To automatically unzip the file contents, check this box. Ignored if the ZIP file contains more than one file. |
Outputs
Output |
Output Type |
Downloaded File |
File |
Downloaded File Size |
Integer |
Downloaded Records |
Integer |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Execute MDX Script
To run a Multidimensional Expressions (MDX) script, add an Execute MDX Script command.
Properties
Input |
Detail |
Application |
Enter the OAC application to run the script in. |
Database |
Enter the OAC database—or cube—to run the script in. |
Script |
Enter the name of the script file to run, with an .msh extension. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Execute MaxL Script
To run a MaxL script, add an Execute MaxL Script command.
Properties
Input |
Detail |
Application |
Enter the OAC application to run the script in. |
Database |
Enter the OAC database—or cube—to run the script in. |
Script |
Enter the name of the script file to run, with an .msh extension. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Export Metadata
To export dimension metadata in a tabular, parent-child hierarchical format, add an Export Metadata command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application to export from. |
Database |
Enter the name of the OAC database—or cube—to export from. |
Dimension Name |
Enter the name of the dimension to export. |
Show Attributes |
To show attributes in addition to the names of each member in the dimension, check this box (optional). If you require only member names in a parent-child format, leave unchecked.
Note: Attributes may take significant time to export.
|
Extended Attributes |
If members have more than 10 attributes, check this box (optional). By default, only the first 10 attributes appear. |
Outputs
Output |
Output Type |
Members Count |
Integer |
Members Export CSV |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Get Variable
To retrieve a substitution variable defined at the application or cube scope, add a Get Variable command.
Properties
Input |
Detail |
Application |
Enter the OAC application with the variable to retrieve. To retrieve a variable defined at the cube scope, leave blank. |
Database |
Enter the database—or cube—with the variable to retrieve. To retrieve a variable defined at the application scope, leave blank. |
Name |
Enter the name of the variable to retrieve. |
Outputs
Output |
Output Type |
Variable |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
LCM Export
To back up cube artifacts to a Lifecycle Management (LCM) ZIP file, add an LCM Export command.
Properties
Input |
Detail |
Application |
Enter the OAC application where the file lives. To check the user directory, leave blank. |
ZIP File Name |
Enter the name of the compressed file to hold the backup files (optional). |
Local Directory |
Enter the local directory where the file is stored. If using as an output in another command, leave blank. |
Number of Threads |
If using a parallel export, enter the number of threads to spawn (optional). |
Skip Data |
To not include data in the backup, check this box. |
Overwrite |
To overwrite an existing backup file, check this box. |
Outputs
Output |
Output Type |
Export ZIP File |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
LCM Import
To restore cube artifacts from a Lifecycle Management (LCM) ZIP file, add an LCM Import command.
Properties
Input |
Detail |
ZIP File Name |
Enter the name of the compressed file containing the backup files. |
Overwrite |
To overwrite an existing LCM Export file on the server, check this box. Otherwise, the command throws an error if a ZIP file with the same name already exists on the server. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Applications
To list the applications that exist on an instance of OAC Essbase®, add a List Applications command.
Properties
None
Outputs
Output |
Output Type |
OAC Applications |
Array |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Databases
To list the databases within a given application, add a List Databases command.
Properties
Input |
Detail |
Application |
Enter the OAC application with the databases to list. |
Outputs
Output |
Output Type |
OAC Databases |
Array |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Files
To list cube artifacts that exist on a given instance, add a List Files command.
Properties
Input |
Detail |
Application |
Enter the OAC application with the files to list. To list files from the home directory on the cloud service, leave blank. |
Database |
Enter the name of the database—or cube—with the files to list (optional). |
File Type |
Select the type of file to return (optional). |
Filter |
Enter the filter criteria of the files to return, using glob syntax such as log_*.txt . |
Outputs
Output |
Output Type |
OAC Files |
Array |
OAC Files as CSV |
File |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Filters
To list Essbase security filters, add a List Filters command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application with the filters to list. |
Database |
Enter the name of the database with the filters to list. |
Outputs
Output |
Output Type |
OAC Filters |
Array |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Locks
To list any locked data blocks or cube-related objects, add a List Locks command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application with the locked objects to list. |
Database |
Enter the name of the database—or cube—with the locked objects to list. |
Show Object Locks |
To display locked files and artifacts, check this box. |
Outputs
Output |
Output Type |
OAC Locks |
Array |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
List Variables
To list the substitution variables defined at the application or cube scope, add a List Variables command.
Properties
Input |
Detail |
Application |
Enter the name of the application with the variables to list. To list variables defined at the cube scope, leave blank. |
Database |
Enter the name of the database—or cube—with the variables to list. To list variables defined at the application scope, leave blank. |
Outputs
Output |
Output Type |
OAC Variables |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Load Data
To load data to a cube, add a Load Data command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application to load to. |
Database |
Enter the name of the database—or cube—to load to. |
Data File |
Enter the name of the data load file. The full path is unnecessary; files are assumed to be in the relevant application or database directory. |
Rules File |
Enter the name of the rules file. The full path is unnecessary; files are assumed to be in the relevant application or database directory. |
Abort |
To abort the command on failure, check this box. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
Start
To start an OAC application or database, add a Start command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application to start. |
Database |
Enter the name of the database—or cube—to start. To start the application, leave blank. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
10 |
Error |
Application or database already started |
Stop
To stop an OAC application or database, add a Stop command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application to stop. |
Database |
Enter the name of the database—or cube—to stop. To stop the application, leave blank. |
Outputs
None
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |
10 |
Error |
Application or database already stopped |
Update Variable
To update a substitution variable defined at the application or cube scope, add an Update Variable command.
Properties
Input |
Detail |
Application |
Enter the name of the OAC application with the variable to update. To update a variable defined at the cube scope, leave blank. |
Database |
Enter the name of the database—or cube—with the variable to update. To update a variable defined at the application scope, leave blank. |
Name |
Enter the name of the variable to update. |
Value |
Enter the new value of the variable. |
Outputs
Output |
Output Type |
Updated variable |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid arguments |
3 |
Error |
General failure |