...
Steps to perform:
Click Overview.
...
2. Go to Under Dimensions tab, click Export button on the right.
...
3. On the export metadata screen, you will see the existing CXO job, might be others as welljobs.
a. create new job. See two screenshots below
...
Click Create.
...
b. select location Select Location to Outbox and select all dimensions which should be extracted.
...
The export job name created in Oracle Cloud and export job file delimiter has to must be later on used in Oracle EPM Adapter in Metadata General Settings.
...
Configure data export job
Go to the Click Overview screen.
Choose Export Data in from the dropdown on the right side of the screen
Create a new data job
Click Create.
Specify the following values:
Location: Outbox
Pick right cube
Choose a delimiter, preferably set it to “Other” Other and use “|”
Smart Lists are not used currently
Dynamic Members: Exclude
Decimals: none None (or discuss with the customer)
Slice definition: take Take Account on rows, Period on columns, set default slice values for all dimensions incl. including POV.
Note: this This configuration will not be used in the actual data extraction, as it will be input to the job API call.
The export job name created in Oracle Cloud and export job file delimiter has to must be later on used in Oracle EPM Adapter in Metadata General Settings.
...
Oracle EPM
...
Adapter Configuration
Configure connection.
Cube
For Use host url for Api Url use host url without any path e.g. for example: https://epm - a000000.epm.em2.oraclecloud.com.
Application name is the same you see in oracleOracle.
For credentials use username combining domain + “.” + username
Example: for picture below username would be a000000.xxxxxxxxxxxxx
Configure dimension mappings. Most standard dimensions would be mapped already – you need to map the custom ones. Number of custom Oracle Dimension doesn’t matter and are only used on our side. You only need to fill in allias by CXO. Fill in the alias corresponding to custom dimension name.
Example:
...
Configure metadata.
Please review instructions for FCCS here.Go to Overview
...
> Dimensions
...
>Extract.
...
Configure Data.
...
Should be filled in consultation with the customer.
- Multiple members are supported and should be separated by comma
...
- Do not use quotes around members (even if they contain spaces)
...
- Do not use “@” before selector methods (like
@ILvl0Descendants(YearTotal))Fill in Account dimension on Row and Period on Column.
Select all other dimensions in any order and fill in desired selectors.
The Order of POV dimensions is important –
...
to parse data extraction file using it. To figure it out fill in at first in a random order, finish configuration and return to the next step after you have successfully run an extraction. (
...
You will see in the logs that data extraction
...
has finished successfully but there
...
are warnings of zero records being mapped).
Download the export data file for your last extraction (it should have at least one record).
Add
...
.
...
zip extension to file if necessary.
Open a file. Identify for any record
...
“Point-of-
...
View” member (it would be few members enclosed in quotes). Identify to which dimension each members belongs. Reorder your
...
POV dimensions in adapter in the same order.
...
Configure schedule.
Create new schedule
...
. Name and schedule
...
are up to the customer (or
...
CXO) and not connected to
...
Oracle configuration.
...
- Initially its best to have “Extract Metadata” enabled.
Create a data slice.
- Multiple members separated by commas are supported.
...
- Do not use quotes.
Click Run now to extract data and metadata.
You can see the progress of the extraction under the Logs tab.
Note:
Selector functions are not supported yet (
...
for example, Children (YearTotal))
...
.
2. Make sure these are not included in Data Slices.
- Use multiple members to replace such functions.
...
Example:
...
Use Run now button to extract data and metadata
...
...