Page Comparison

...

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 review instructions for FCCS here.

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.
    

    

14. Click Run now to extract data and metadata.
    

    

...