...

1. Go to the Overview screen

2. Choose Export Data in the dropdown on the right side of the screen
   

   Image RemovedImage Added

3. Create a new data job

   

4. Specify the following values:

   1. Location: Outbox

   2. Pick right cube

   3. Choose a delimiter, preferably set it to “Other” and use “|”

   4. Smart Lists are not used currently

   5. Dynamic Members: Exclude

   6. Decimals: none (or discuss with the customer)

   7. 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.

...

• 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)

Logging

• The log level can be set in appsettings.json in "LogLevel" property (Both Web project and CLI project have own appsettings.json file)

• Location of the log files:

  • CLI command {CXO-Installation-Dir}\Oracle Cloud EPM Adapter\Extraction\logs

  • Web application {CXO-Installation-Dir}\Oracle Cloud EPM Adapter\Web API\logs

• Log files are split into two file types

  • nlog-all -contains cxo defined logs and logs generated by other Microsoft libraries. Usually it is more verbose

  • nlog-own-detailed -contains logs defined by cxo with more detailed information then info in “nlog-all“ and additionally filters logs created by Microsoft libraries.

• Logging to the console in CLI tool

...