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

Martina Iovino-Oracle · Jun 20, 2025 1:53PM

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 · Jun 22, 2025 3:26PM

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.

MFA for Oracle Community

Oracle Fusion Data Intelligence

Categories

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

Best Answer