Friday, February 5, 2021

Financials Cloud for EPM folks - Hierarchies

This is the second post of my Financials Cloud for EPM folks series, in these posts I'm trying to familiarize EPM professionals with ERP Financials Cloud because we all have to interact and work with ERP cloud at some point. 

In the first post, I covered value sets and in this post I will briefly writing about hierarchies. In the ERP world metadata is defined in two ways:

1- Value sets (flat lists) primarily used for transactions, journal entries and all kind of ERP related configuration/

2- Hierarchies - primarily used for reporting and budgetary control purposes (hierarchical reporting in ERP? Yes, there are multiple Essbase cubes in ERP for reporting ad budgetary control purposes)

Why is it important for us in EPM world? Well, unless your metadata is 100% synced between Planning/Consolidation applications and ERP then there is always a need to get metadata information from ERP. Whether it is for manual updates, description changes, member additions/movements in the hierarchy etc.

So let's get on with it and show how to access your hierarchies in ERP cloud.

From Settings and Actions go to Setup and Maintenance

Search for "Manage Account Hierarchies" and click on it, as you can see below this task is located in Financial Reporting Structures.

In Manage Account Hierarchies you will see all the available dimensions, and the associated tree versions. (Tree version is another copy of the hierarchy).

If you expand any of the nodes you will find the tree version(s) and the active/current one. From there, simply click on Actions -> View Tree Version.

And here you can navigate the hierarchy in a simple way. Let's say you are trying to load actual data in Planning and the rule is failing because of a missing member, the log will tell you what is the member name but it won't tell what is the parent member! So from here you can easily figure it out.

Hope you find it useful.

1 comment:

  1. Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. Ottawa bookkeeper