Sort options for evdre reports

[Former Member]

We have a standard ECDRE report that we use parameter SortCol1 to sort the report by account alphabetically (A – ascending; D – descending). When we remove this setting, the report will sort per the account hierarchy but parent account comes before the child accounts. Is there a way to sort the EVDRE report exactly the opposite order of the account hierarchy like below. If it’s not possible for BPC 7.5, is it possible for 10.1 with EPM reports?

----child account A1

----child account A2

  …..

--Parent account A

----child account B1

----child account B2

  …..

--Parent account B

----child account C1

----child account C2

  …..

--Parent account C

[romuald_voisin]

This function is native to version 10 et 10.1.

With Evdre function, it seems to me this case is not expected. We bypassed the concerns by creating a property in the Account dimension that contains the number of display account order. You just have to sort out this property in the sort range

[Former Member]

Yes. Versions 10.0 and 10.1 both have this functionality.

[jrg_finster3]

In your Memberset Settings you can use PARENTAFTER.

But this only works for some memberset Functions like "ALL"

Example:

Memberset: SELF,ALL,PARENTAFTER

Regards

Jörg