Skip to Content
avatar image
Former Member

Local Member description for actual calculation

Dear Friends.

I have a nested report with CATEGORY, TIME, PRODUCT, ACCOUNT dimension in row and ENTITY in column. User need to create multiple local member toward the end of the row axis. The CATEGORY and TIME dimension will only have one member (e.g. ‘Actual’ and ‘2016.TOTAL’). PRODUCT & ACCOUNT will have multiple member.

In the attached screenshot when I create local member, it by default take the member in last row for PRODUCT dimension(highlighted in ‘Yellow’). But the user want that local formula should show the description of the formula. For example the row highlighted in ‘Green’ is calculation for TOTAL_PRODUCT and NET_INCOME – FXXX. Similarly the row highlighted in ‘Blue’ is calculation for CFO_TOTAL and PRE_TAX_INCOME – OTH_INC_EXP_NET.

How can I achieve this requirement from client.

Thanks,

Rahul

sap.png (23.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 21, 2017 at 05:23 PM

    Please show screenshot of the local member setup!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 21, 2017 at 05:48 PM

    Hi Vadim,

    Attached is the screenshot of the two local member setup!

    Thanks,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22, 2017 at 07:24 AM

    Looks like you are creating local members automatically using local member recognition! And the formula is static with fixed positions.

    In this case simply don't use local member :) use Excel formulas on the report without local member recognition!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 02:25 PM

    Vadim, the report is dynamic and not static. If I use excel formula, then it won't work if the report expansion changes.

    Thanks,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded