Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Best approach to build OAC reports for EPM cloud data
Answers
-
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 OAC2 -
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
1 -
Thanks for your response @Benjamin Arnulf-Oracle
I will try this today and update the progress.
1 -
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
0 -
Remove the Account Name Filter. Drag Hierarchy to Filter and use Selection Steps. You might need to enable it in advanced settings
1 -
Ok, will try to find that option and enable it. Thank you @Wayne Van Sluys
1 -
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?
0 -
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.0 -
No Problem, I understand. I will try to find the root cause and fix it.
Thanks @Wayne Van Sluys
0 -
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
0
