Skip to Content

SAP Analytics Cloud - Struggeling with sorting option in tables

Hi experts,

I am just struggeling a bit with the sorting options within tables used in a story on SAC.

In our story we have several pages with tables based on the same live model with different filters.

In designtime the tables are sorted by a specific date dimension, the widget filter is set to previous and current year.

When the user opens the story the sorting is displayed correctly. But when he wants to change the sorting within the tabel e.g. by a measure from highest to lowest no correct sorting is applied. The sorting within the table changes but not by the specified measure or dimension. The table details show that there is a sorting on the measure but that is not applied on the table.

Some example screenshots:

Initial table view

Sorted by the first column from new to old (highest to lowest).

Usewr wants to change sorting, wants to see the highest values for measure Opp: U... on top:

Table Details change, but sorting not correct:

It seems as if it is now sorted by first column in the opposite direction from lowest to highest.

Does anyone has an idea concerning this behaviour. As stated we are using a live connection on BWonHANA 7.50 SP16.

Is there any way to restrict sorting for the user in design time? Do I have to do anything in the BW query seetings?

Would be nice if I can get some help.

Regards

Kjell

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.