ebitda in a FSV

[sap_user62]

Hello Friends,

Env- BPC 10.1 Standard/BW7.4

I have a requirement to populate ebitda in BPC. We have separate account nodes for each part that comprises ebitda in our current FSV. But they are scattered in a hierarchy.

Do we create a separate account hierarchy to support this requirement. (duplication of existing nodes/accounts - more admin work)

or will ebitda be another account which gets populated using member formulas or script logic. If this is the case do we put this account outside the hierarchy so that we are not double counting.

What is the optimal way of dealing with these kind of non-gaap measures.

(We might a newer requirement for an additional Mgmt ebitda which will is combination of Functional area and accounts)

Thanks for your time

Ed.

[former_member186338 · Accepted solution]

You can do what ever you want:

1. Have EBITDA in the standard hierarchy (looks like not possible)

2. Create extra hierarchy with duplicated nodes.

3. Use EBITDA member with dimension member formula (members with dimension member formula are not aggregated in hierarchy!)

Try 3rd option - simpliest!

Script logic is overkill for this scenario.