Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 27, 2017 at 08:56 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2017 at 07:22 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 28, 2017 at 11:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 28, 2017 at 11:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 29, 2017 at 05:15 AM

    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();

    }

    Add comment
    10|10000 characters needed characters exceeded