Skip to Content
0

how to sort measures on Hierachy structure BEx Query in Cross tab Design Studio

May 27, 2017 at 03:11 AM

156

avatar image

Hi All, I have cross tab on top BW query which has LOB hierarchy restricted with local selection in the rows and trying to sorting for measure using SORTBYMEASURE method but it is not working on entire structure, however if we filter on specific LOB on info chart and apply that on cross then sorting is working fine on measure which is fine but if we refresh the entire info chart for all LOB hierarchy then it is giving dump as it unable to sort on hierarchy, Please advise if there is anyway to sort or remove the sort automatically when the info chart refreshes for all LOB hierarchy.

8orgo.png (82.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Tammy Powlas
May 27, 2017 at 08:56 AM
0

When you say "dump" do you mean short dump back in BW? What does ST22 in BW say? Perhaps you need to "patch up" BW?

Share
10 |10000 characters needed characters left characters exceeded
Ravi Kumar Arikatla May 27, 2017 at 07:22 PM
0

HI Tammy, Thanks for reply, no it is in BOBJ Design studio saying conflict on Sorting if we refresh the info chart for all LOB's. Please advise if there is any way to avoid on Select.


cktia.png (68.4 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Which version and SP of BW, Design Studio and BI platform are you using?

0
Tammy Powlas
May 28, 2017 at 11:10 AM
0

Hi Ravi - I searched the SAP Notes, and 82 notes are returned when I search "Design Studio crashes". Here is a recent one: https://launchpad.support.sap.com/#/notes/2389834/E - I recommend searching the notes to see if one of the notes is relevant to your situation

Share
10 |10000 characters needed characters left characters exceeded
Ravi Kumar Arikatla May 28, 2017 at 11:08 PM
0

Thanks Tammy for checking, I reviewed all of them but could not find related to this issue. However I have raised an SAP OSS note with high priority. Let's see what SAP will say about this error.

Share
10 |10000 characters needed characters left characters exceeded
Ravi Kumar Arikatla May 29, 2017 at 05:15 AM
0

I resolved the problem to consider the length of selected value in the chart and if the entire chart refreshed then putting back to start so I do not need to worry about clearing the sorting in cross tab.

var z = INFOCHART_MTDPL.getSelectedMembers("00O2TOHK8ZQ4KVR55PKN2EK4H").length;

var X = INFOCHART_MTDPL.getSelectedMember("00O2TOHK8ZQ4KVR55PKN2EK4H");

if(z==1)

{

DS_9.setFilter("00O2TOHK8ZQ4KVR55PKN2EK4H", X);

DS_4.setFilter("00O2TOHK8ZQ4KVR55PKN2EK4H", X);

DS_9.sortByMeasure("00O2TOHK8ZQ4KVT02RF39PJBQ", true);

DS_4.sortByMeasure("00O2TOHK8ZQ4KVT7YPZSA14YS", true);

}

else{

State.backToStart();

}

Share
10 |10000 characters needed characters left characters exceeded