Scenario 2: Import Data, Run a Calculation Script, and Copy Data from a Block Storage Database to an Aggregate Storage Database
This scenario shows how to use the EPM Cloud REST APIs to import data, run a calculation script, and copy data from a block storage database to an aggregate storage database.
Example 5-4 Java
public void integrationScenarioImportDataRunCalcCopyToAso() throws Exception {
uploadFile("data.csv");
executeJob("IMPORT_DATA", "loadingq1data", "{importFileName:data.csv}");
executeJob("CUBE_REFRESH", null, null);
executeJob("PLAN_TYPE_MAP", "CampaignToReporting", "{clearData:false}");
}
Common Functions: See Common Helper Functions for Java.
Dependent APIs: see Java Sample – UploadFile.java and Java Sample – ExecuteJob.java in Upload and Download Files.
Example 5-5 cURL
funcIntegrationScenarioImportDataRunCalcCopyToAso() {
funcUploadFile "data.csv"
funcExecuteJob "IMPORT_DATA" "loadingq1data" "{importFileName=data.csv}"
funcExecuteJob "CUBE_REFRESH","cubeRefresh"
funcExecuteJob "PLAN_TYPE_MAP" "CampaignToReporting" "{clearData=false}"
}
Example 5-6 Groovy
def integrationScenarioImportDataRunCalcCopyToAso() {
uploadFile("data.csv");
executeJob("IMPORT_DATA", "loadingq1data", "importFileName=data.csv");
executeJob("CUBE_REFRESH", "cubeRefresh", null);
executeJob("PLAN_TYPE_MAP", "CampaignToReporting", "clearData=false");
}