...
The export job name created in Oracle Cloud and export job file delimiter has to be later on used in Oracle EPM Adapter in Metadata General Settings
Configure data export job
Go to the Overview screen
Choose Export Data in the dropdown on the right side of the screen
Create a new data job
Specify the following values:
Location: Outbox
Pick right cube
Choose a delimiter, preferably set it to “Other” and use “|”
Smart Lists are not used currently
Dynamic Members: Exclude
Decimals: none (or discuss with the customer)
Slice definition: take Account on rows, Period on columns, set default slice values for all dimensions incl. POV. Note: this configuration will not be used in the actual data extraction, as it will be input to the job API call.
...
Use Run now button to extract data and metadata
...
You can see the progress of the extraction in the logs tab
After successful extraction Process cube from SQL Server Management Studio (this is temporary solution. This process will be automated in the future)
...