Skip to Content

SAP Design Studio 1.6 Drag&Drop Table-Custom-Sort as MemberArray or String ?

Jul 03, 2017 at 01:25 PM


avatar image


In SAP Design Studio 1.6 during the application rumtime it is possible to custom sort the members of a Dimension in the crosstab with drag&drop.

Alphabetical sorting:

Custom sort (drag&drop):

Would it be possible to get the sorting-order as MemberArray or String from crosstab or datasource ?

Example: NA_2, SA_2, EU_3, EU_1, SA_1, EU_4, EU_2, NA_4, SA_4, NA_3, SA_3, NA_1

If i catch it with <foreach> it will always shown in alphabetic order.

Best regards,


q1.png (8.4 kB)
q2.png (77.5 kB)
q3.png (4.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mustafa Bensan Jul 04, 2017 at 03:53 AM

Hi Andre,

Your issue is a known limitation of Design Studio whereby the sort order of the list returned by getMembers() is based on master data sort order, completely independent of the data source result set sort order that appears in the Crosstab. While there is no method to achieve the desired result with standard functionality, I can confirm that you can retrieve the desired sorted array using the SDK Community Data Iterator component with the following steps:

1. Add the Data Iterator to your application and assign the same data source as your Crosstab;

2. In the "On Data Change" event of the Data Iterator include the following script code:


var myColumns = me.getMeasures();

var myColumnKey = "";
var myColumnText = "";

myColumns.forEach(function(column, index) {
 myColumnKey = column.key;
 myColumnText = column.text;
 LISTBOX_1.addItem(myColumnKey, myColumnText);

In the above example, for demonstration purposes I am populating a List Box with the array values but you can process as desired.



10 |10000 characters needed characters left characters exceeded