How do I add a missing hierarchical dimension to an OOTB Subject Area?

Question

Hi,

I'm trying to add the Department Hierarchy to an existing ootb subject area in FDI.

I see that the hierarchy is included in other subject areas, but it's missing in the one I need to use. I tried doing this through augmentation, but I'm having trouble understanding which is the right pvo and how the it relates to the other tables.

Any suggestions?

Thanks in advance.

Bhaskar Konar · Accepted Answer

https://community.oracle.com/products/oracleanalytics/discussion/26275/how-do-i-add-a-department-hierarchy-dimension-to-an-ootb-subject-area

Hi @Martina Iovino-Oracle,

Please take a look into the following note which might be very useful for the initial understanding and a good starting point.

https://blogs.oracle.com/analytics/post/create-a-custom-alternate-presentation-hierarchy-in-oracle-fusion-data-intelligence

Hope this help.

Thank you.