Skip to Content
Former Member
Jun 28, 2015 at 06:52 PM

Sort in Olap for Analysis based on Bex queries



We are using Analysis workspace report (OLAP for analysis) based on bex queries.

We can NOT modify the sort by default imposed by OLAP for analysis, at navigation tab and cross table tab.

1) On the navigation tab : OLAP displays the bex objects using automatcally a sort by decription.
We would like modify this bex objects displaying (by grouping date axes at the first, then organisaion axes....).

2) When we add an object to the cross tab (result), OLAP uses automatically a sort by text (on the values).
We would like using rather that a sort by keys. In other words, we don't like having to do the sort by key after each new navigation.

Do you have any idea to resolve that ?

Thx a lot.

Bo version : 4.1 Support Pack 4 Patch 4
BW version : SAPKW74009.