Page Comparison

...

• CXO version 21.1.3 (or higher)

• CXO Identity provider

• .NET 5.0 has to be installed

• .NET 5.0 Hosting Bundle:
  https://dotnet.microsoft.com/download/dotnet/5.0

• 6.0

...

1. Configure connection.

   1. Cube

   2. 

      Use host url for Api Url without any path for example: https://epm a000000.epm.em2.oraclecloud.com.
      Application name is the same you see in Oracle.
      

      

   3. For credentials use username combining domain + “.” + username
      Example: for picture below username would be a000000.xxxxxxxxxxxxx
      

      

2. 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 by CXO. Fill in the alias corresponding to custom dimension name.
   Example:

3. Configure metadata.
   Please follow instructions for FCCS here and then proceed.

4. Go to Overview> Dimensions>Extract.
   

   

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

6. Fill in Account dimension on Row and Period on Column.

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

8. Download the export data file for your last extraction (it should have at least one record).
   

   

9. Add .zip extension to file if necessary.

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

    

11. Configure schedule.

12. Create a 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.

13. Create a data slice.
    - Multiple members separated by commas are supported.
    - Do not use quotes.
    

    Image RemovedImage Added

    Schedule the time when metadata and data should be extracted from under the Scheduling tab. A schedule can be on a daily or a weekly basis, and the extracted data set is defined with a combination of Period, Year, and Scenario (for example Q1 2020 Actual).
    

    

14. Select the Full option to load the entire metadata. If there are smaller changes like a new dimension structure or if you need to perform only an incremental extraction, the option Incremental can be selected to get faster results. When this option is selected, although the entire metadata is loaded, only the delta/changes get added to the cubes list.

15. Click Run now to extract data and metadata.
    

    

    You can see the progress of the extraction under the Logs tab.

...