Finance Account Hierarchy modeling question

Ebin Cherian

Oracle Analytics Server 6.4
Oracle Database 12c

We are in the process of migrating to a cloud based financial consolidation tool. Tool will provide an export of the account hierarchy to build the income statement and Balance sheet and another export with the corresponding amounts (Fact Table). OAS users need to be able to create new reports including information like Gross Profit, Total assets etc. But these information are at different levels of account hierarchy which is of type skipped. What is best way to model this. I have 500+ lines in the account hierarchy table which include details for Income statement and Balance sheet.

Ashish-Oracle

@Ebin Cherian Since you are using OAS I am assuming you are using the Model Administration tool for your modelling here.

Refer: Create Dimensions in Level-Based Hierarchies

https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/create-and-manage-dimensions-level-based-hierarchies.html#GUID-EDB3A514-3100-4F61-A7D8-BC4227B0B736

NOTE: As your Dimension is a skip-level dimension, you need to select Skipped Levels.

Mallikarjuna Kuppauru-Oracle

Hi @Ebin Cherian

Are you planning to build an Skip level hierarchy then refer below -

Skip-level hierarchy

https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/create-and-manage-level-based-hierarchies.html#GUID-A79980B2-8D44-4C4A-A9D7-45C8C7A205D6

Regards,

Arjun