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");
}