Skip to Content
0

SAP Design Studio - Logical Grouping

Nov 30, 2016 at 06:07 PM

55

avatar image

Hello Everyone,

We are new with SAP Design Studio and are using it with BEx as source. We have column coming in our cross tab for a dimension as an text which is Plant Name , whose values are stored in numerical codes : for e.g 3001, 6001 , 7001 to 9001 which is fixed always. Now in Webi we created a report using input control where we were able to group them under the plant name , in the same example like 3001 is always a PLANT A and 4001 to 9001 its always PLANT B, so our input control was select plant and when the user used to select PLANT A, they used to see only 3001 like that.

Now here in DS, we are trying to achieve this by if else, using checkbox like

if (listbox1.getselectedvalue() == "PLANT A" {

DS1.setFilter(Plant Name; "3001")

But it doesn't seems to be working, first of all we are not able to select the values which I was expecting to come after pressing ctrl+space , second its not at all getting applied in the crosstab.

Please suggest where we are missing things.

Shrutika V

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Nov 30, 2016 at 06:45 PM
0

Hi - you should have Listbox code on startup - something as follows (assuming your InfoObject is called ZPLANT):

LISTBOX_1.setItems(DS_1.getMemberList("ZPLANT", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 5));

Then on the Listbox itself, have this on the On Select statement:

DS_1.setFilter("ZPLANT", LISTBOX_1.getSelectedValues());

I don't think you need the IF statements in there.

If you are new to the product I recommend reviewing the online free tutorials here: https://www.youtube.com/playlist?list=PLs5htBIwERYWFt-ixnVgxsUGvQpR9E8hI

Tammy

Share
10 |10000 characters needed characters left characters exceeded