Skip to Content
0

Base members in Page-axis

Oct 23, 2016 at 12:45 PM

84

avatar image

hello all,

We want to add all Base-Members to the page axis, so we can use 'Exclude Members' from Report Editor. But we are only allowed to add 'member only' to the Page-axis? Any idea how to add them on base-level? (clicking them manually not possible as only 30 are allowed).

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Oct 23, 2016 at 02:16 PM
1

First you are using incorrect tag!

Second - use parent to aggregate data and select parent in page axis.

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

P.S. If you want to use different sets of base members you have to create different parents (may be in different hierarchies)

0
Priyanka Jagtap Oct 24, 2016 at 06:59 AM
1

Hi K,

Vadim is right....best is to use the parent member in the page axis! Page axis does have the limitation of 30 members! But you do have a strange requirement of taking all base members in the page axis and then Exclude members!!!! Can you explain the report requirements so that we can think if any other possible solutions can be applied.

JP

Share
10 |10000 characters needed characters left characters exceeded
John Leggio
Nov 08, 2016 at 07:28 PM
0

Hi K,


To get around the 30 member limit please apply these notes:

2322294 - Multiple selection in page header does not aggregate values

https://launchpad.support.sap.com/#/notes/2322294

2016928 - Move aggregation logic for multiple selections in page axis to BPC backend

https://launchpad.support.sap.com/#/notes/2016928

  1. Apply this note or upgrade to relative support packages.
  2. Add a global IMG parameter 'PAGEAXIS_AGG_IN_BACKEND' with value 'X'.
  3. Upgrade EPM-Addin to SP18 Patch01, SP19 or higher support pachages.
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Note 2016928 will increase the limit to 300 but it's not a solution in general!

0

Yes agreed.

K Krooymans , what's your plan for this? What are you trying to achieve?

0