Skip to Content
0

Avoid sorting members in a report

Jan 31, 2017 at 02:04 PM

72

avatar image
Former Member

Hello,

I am using EPM SP 27 and SAP BPC 10.1 Embedded.

When I am creating a report I want a fixed order for the members. For instance:

However, when I click on OK, this is the result I obtain:

It is sorting the members as in the hierarchy:

But I do not want that, what I want is the fixed order that I showed before (in the first image).

Thanks in advance.

sap01.png (15.4 kB)
sap02.png (4.1 kB)
sap03.png (23.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jan 31, 2017 at 02:53 PM
0

If you don't use member sorting then the order will be the same as in member selection.

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

I am not using any member sorting and, as you can see from the image, they are ordered as in the hierarchy.

sap04.png (71.1 kB)
0
Vadim Kalinin Jan 31, 2017 at 03:44 PM
0

Unable to reproduce your issue (EPM SP27):


memsel.png (152.5 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Ups, sorry! Didn't mentioned that you use embedded... may be the issue is because of embedded. For embedded AO is recommended.

0
Former Member

Maybe the problem is in the query, could you show me the configuration of your query in the BEx?

Thank you again

sap08.png (233.6 kB)
0