nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Best approach to build OAC reports for EPM cloud data

Santhosh_N

Hello All,

We have a requirement to build reports in OAC for EPM cloud planning data, what is the best approach to do achieve this?

Direct connection to EPM cloud from OAC DV.

RPD (connect to EPM and model the data).

Use ODI to extract data from EPM cloud and load into DW .

Appreciate any insights on this, thanks in advance.

Thanks

Find more posts tagged with

Oracle Analytics Cloud

EPM

OAC DV

Accepted answers

Wayne Van Sluys

You need to essentially build the POV via Filters.

You will also need to change properties on filters to not limit values based on other dimensions

All comments

Wayne Van Sluys

Just like you would do a Smart View retrieve, you need to create a Point of View (POV). Every dimension needs to either be a row, column or filter.

If you have a SME that provided a Smart View retrieve, try to replicate in OAC

Santhosh_N

Ok, now i have some understanding on this, let me work with my EPM expert and try to build this in DV.

Thank you @Wayne Van Sluys and @Benjamin Arnulf-Oracle

I will update the progress.

Thanks

Santhosh

Santhosh_N

https://community.oracle.com/products/oracleanalytics/discussion/comment/67218#Comment_67218

Thanks for your response @Benjamin Arnulf-Oracle

I will try this today and update the progress.

Santhosh_N

https://community.oracle.com/products/oracleanalytics/discussion/comment/67221#Comment_67221

@Wayne Van Sluys

I am able to replicate the smartview, but how to replace 'Account Name' column with 'Account' hierarchy column from the Account dimension? when i replace it with Account hierarchy column, it says 'No Data Found'. I see you have used this hierarchy column in your screenshot.

Below is what i built so far

Thanks

Wayne Van Sluys

Remove the Account Name Filter. Drag Hierarchy to Filter and use Selection Steps. You might need to enable it in advanced settings

Santhosh_N

Ok, will try to find that option and enable it. Thank you @Wayne Van Sluys

Santhosh_N

@Wayne Van Sluys

Good Morning, I have enabled the selection steps in the advanced settings and replaced Account name with Account Hierarchy in filters.

I still don't see data, i am i missing anything here?

Wayne Van Sluys

Without seeing your workbook and reviewing logs I am not able to help any further.

I would suggest looking at the Developer tab and looking at the physical query that is being generated.

Santhosh_N

No Problem, I understand. I will try to find the root cause and fix it.

Thanks @Wayne Van Sluys

CPavan

Hi @Wayne Van Sluys / @Benjamin Arnulf-Oracle

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