EPM Cloud data(RealTime) and ADW data validation through OAC

CPavan

Hi Everyone

We were able to create a report in OAC using EPM Cloud connectivity. Is there a way to leverage this workbook to validate the data that is loaded into ADW?

Our end goal is to validate EPM data against ADW. We have a subject area built on top of ADW that is currently being used, and we want to ensure that the data retrieved through this subject area matches the data in EPM Cloud.

If there are any alternative approaches or existing threads related to this requirement, we would appreciate your guidance.

Thanks & Regards,

Pavan

Sumanth V -Oracle

@CPavan - Thanks for using Oracle community!

Please check if these approach helps.

• Add a second data source in the same OAC workbook pointing to your ADW subject area.
• Build matching tables/visuals using the same dimension keys and measures from:
  • EPM Cloud
  • ADW Subject Area
• Apply shared dashboard prompts/filters so both visuals respond to the same selections.
• This allows direct side-by-side comparison for quick validation and reconciliation.
• Create “difference” calculations (e.g., EPMValue - ADWValue) to highlight mismatches.

Hope it helps!

CPavan

Thank you @Sumanth V -Oracle , let me give a try and update here.

CPavan

Hi @Sumanth V -Oracle

The below mentioned particular step is not working as expected as we are not doing any blending, the EPM and OAC subject area both are different data sets and they don't have any join between them. So applying shared dashboard prompt is becoming bit difficult and also creating a custom measure as well, could you please let me know your thoughts on this.

Apply shared dashboard prompts/filters so both visuals respond to the same selections.

Thanks & Regards,

Pavan

Wayne Van Sluys

to use shared values for prompt you need to use parameters in the filter.

There is no way to join EPM data to ADW data in the workbook.

Thinking outside of the box…Not sure if creating a Subject Area on the EPM connection would get you closer. You can create Datasets from the Subject Areas and maybe then join them for combined analysis