Skip to Content

Getting value of dimension in SAP Design Studio

Dear Experts,

I have a following requirement in Design Studio:

  1. I have to select one customer from CROSSTAB_1 and pass this selected customer to another datasource DS_2.
  2. After this filter, I have to get the value of a characteristics "LEVEL" in DS_2 which holds numeric values (1 , 2 or 3).

For point 1, I have written the following code:

DS_2.setFilterExt("0CUSTOMER",CROSSTAB_1.getSelectedMember("0CUSTOMER"));

I don't understand how to write code for point number 2.

Please help me.

Thanks and Regards,

Nitesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 04, 2017 at 01:19 PM

    Hey,

    What do you want exactly? Do you want to retrieve the text of a char where the key is 1, 2 or 3?

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I think you would like to play with the formats, can you try out codes like:

      var string_value = CROSSTAB_1.getSelectedMember("ZSYDOSTYP").text;
       var int_value = Convert.stringToInt(string_value);

      grtz

      Koen

  • May 04, 2017 at 02:17 PM

    Hi Nitesh,

    This appears to be a cascading filter scenario. For the second point you should:

    a) Make sure that in the datasource Initial View editor the Members for Filtering option of DS_2 is set to "Values with Posted Data Only" for dimensions 0CUSTOMER and LEVEL;

    b) Apply the script DS_2.getMembers("LEVEL", 99) after your setFilterExt() script in order to retrieve the filtered values of LEVEL.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded