loadData

Loads data into a calculation cube using a file available in profitinbox.

A Service Administrator uses the uploadFile command to load files into profitinbox.

Applies to

Profitability and Cost Management

Required Roles

• Service Administrator
• Power User

Usage

epmautomate loadData APPLICATION_NAME dataFileName=File_Name PARAMETER=VALUE where:

• APPLICATION_NAME is the name of the Profitability and Cost Management application into which you want to load data
• dataFileName=File_Name specifies a data load file available in profitinbox.

  Data file name must be enclosed in double quotation marks.

• PARAMETER=VALUE indicates runtime parameters and their values to load data. Specify as many parameter and value pairings as the process requires. Valid parameters and their values:

  • clearAllDataFlag=true|false specifies whether to clear existing data in the application cube
  • dataLoadValue=OVERWRITE_EXISTING_VALUES|ADD_TO_EXISTING specifies how to handle existing data

Example

epmautomate loadData BksML12 dataFileName="data1.txt"clearAllDataFlag=true dataLoadValue="OVERWRITE_EXISTING_VALUES"