Skip to Content
0

Local Member description for actual calculation

Mar 21, 2017 at 04:47 PM

34

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin Mar 21, 2017 at 05:23 PM
0

Please show screenshot of the local member setup!

Share
10 |10000 characters needed characters left characters exceeded
Rahul Singh Mar 21, 2017 at 05:48 PM
0

Hi Vadim,

Attached is the screenshot of the two local member setup!

Thanks,

Rahul


sap-1.png (42.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 22, 2017 at 07:24 AM
0

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!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. "CATEGORY and TIME dimension will only have one member" - then move CATEGORY and TIME to page axis!

0
Rahul Singh Mar 22, 2017 at 02:25 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Not clear!

In case of dynamic report EPMPOSITION(21) will be also incorrect :)

It's better to explain the real requirements for the local member!

0