Skip to Content

Functional Area Hierarchy

Hello Friends,

We have a reporting requirement from business to show the PL statement with functional area dimension only. The hierarchy structure is defined by business. Currently we have a PL of GL accounts, which does not completely meet the needs.

After building the hierarchy we realised that the signage of the numbers in the functional area PL is reversed for Expense FA(eg support costs) if an Income GL account hierarchy node is selected for account dimension in the context, and if we select a Expense GL account node, the Income FA's have their signs revered.

Users want to have a dynamic PL based on FA which has a capability of drill down based on the FA hierarchy. Any ideas on how to fix the signage and allow drill-ability.

Attached sample report

Thanks for your time

Ed.capture.png

capture.png (23.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Feb 12 at 06:26 AM

    The sign on the report is depending on ACCTYPE property of ACCOUNT dimension - look on MEASURE formula. Theoretically you can create custom measure based on some function area property, but I don't think it's a correct approach.

    P.S. Please don't use "Insert File" instead of "Insert Image"! I will not answer questions with "Insert File".

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 02:48 PM

    Thanks Vadim for your reply. I have attached the screen shot as an image.

    I came across this link, which states to use custom measures to define the signage of functional area node by defining a custom account type property on the functional ara

    http://www.infogility.org/insight-blog/need-more-than-one-account-type-dimension-in-a-sap-bpc-model-it-is-possible/

    Do you think this method will have severe reporting impact.

    I need to tell the business there is a workaround but we will have a list of problems and sap does not recommend it.

    Thanks for your time

    Ed

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13 at 03:42 PM

    I have attached the high level functional area hierarchy and top level GL account hierarchy as an image.

    If we define custom measures on functional area dimension, and use those measures instead of the BPC standard measures would it give us correct results if we pull in account dimension too in the reports?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18 at 09:02 PM

    It seems like your trying to create a new "GL" structure with your FA structure. Is the FA being derived in FI e.g.: via FI substitution?

    Because usually FA is a further break down of the account movement but never the movement itself. E.g.: you can have something like production, IT, S&D, HR... These are driven out of business rules such as, as you said, based on the Cost Object...Profit Centre... The account plus the FA can then tell later on if the item is an SG&A, Selling Expense, or a production cost... E.g.: Account Wages + FA PROD = "prod. cost"... or Account Wages + FA SALES = Cost of Sales - Salary Direct Cost...

    If your current Account Structure doesn't support the reporting requirements, what I recommend is to create a secondary Account structure in which you would fill with data based on the rules you'd apply for the structure you posted above. If this is required only for actuals, you can play around the conversion files. Or, of course, use Script Logic to do the job.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18 at 11:45 PM

    Thanks Lucas for your reply.

    The functional area in ecc-gl transaction data is derived by cost center's functional area,It is not derived by GL Account's functional area.

    The business requirement is to show a reports for cos, support costs, direct costs etc using functional area hierarchy only, without merging the account dimension.

    When you suggest an alternate account hierarchy, would that be a high level hierarchy of new nodes in account dimension which corresponds to functional area nodes?

    Example - Move the data sitting in functional area for one of the support costs to an alternative account hierarchy element "support costs"?

    We have this requirements for actual, budget and forecast.

    Add comment
    10|10000 characters needed characters exceeded