No Problem, I understand. I will try to find the root cause and fix it. Thanks @Wayne Van Sluys

@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?

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

@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 for your response @Benjamin Arnulf-Oracle I will try this today and update the progress.

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

Thanks @Wayne Van Sluys So I need to reference all the dimensions in my cube in the filter bar with this filter property (filters to not limit values based on other dimensions) even i am not using all of them in the report, correct? Thanks

Hello @Ambient Yes, i am working with an EPM specialist, he was able to quickly build the prototype in smartview but adding the same columns to the DV workbook is not returning any results. Please share any document links for building these type of reports in DV. Thanks

Hello @Wayne Van Sluys Thanks for your response. I tried with adding two columns with filters applied on both columns but still did not return any data. Can you share any documentation link (if any) for building reports in the DV for EPM data? Thanks

Hi @Benjamin Arnulf-Oracle Thanks for your response. I tried with the direct connection to EPM cloud and it's not working as expected, when i add one column from a dimension it displays data but when i add another column from a different dimension (both are from same cube), it is not returning any data. I am not sure if i…

Hi @Ajinkya Vyawahare What is the reason for building the reports via RPD approach when OAC can directly connect to EPM cloud? We have requirement to build reports in OAC for EPM cloud data, we are evaluating different approaches (Direct connection, RPD and use ODI to pull and load into DW) so want o know more about this…

@Cade Johnston - we have the same requirement and we are able to achieve it by making changes in RPD. Create a two separate Logical tables, one joined to custom security dimension and other without join. Then add them to the presentation layer. Create two different reports, users with limited entity access are assigned to…

It looks great and have all the information related to Oracle Analytics at one place. Thank you

Can you please share the link for this New Oracle Analytics Community Website?