Skip to Content
0

Adding Local members to the report

Mar 24, 2017 at 09:32 AM

23

avatar image
SREEJA V

Hi All,

I have a requirement in my project to create the report structure as below in table 2, where I need to create Component total and Stage totals as local members which will sum up to show the totals of each component and sum of all components under one stage respectively.

Components and stage are related via master data and attributes.

Please find the same below in table 1

Please help me, how the same can be accomplished in sheets. Components, Fund and Fundcenter are dynamic members in the sheet that may change based on the selection parameters.

Regards,

Sreeja V

tcqdh.png (13.3 kB)
igmfn.png (2.5 kB)
SAP Business Planning and Consolidation, version for SAP NetWeaver
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Vadim Kalinin Answered Mar 24, 2017 at 09:37 AM
0

Actually you need Fund total :)

Do you have parent member for Fund1,2,3? Then use it instead of local member!

Same for stage total - parent of Component!

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
SREEJA V
Mar 30, 2017 at 07:53 AM

Thank you.. I was trying the grouping based on Component dimension properties instead of Fund dimension.

Regards,

Sreeja V

0
Vadim Kalinin
SREEJA V
Mar 30, 2017 at 07:56 AM

Properties are not for aggregation! For aggregation use hierarchy parents!

0
Comment