Compounding list of values in Design studio dimension filter

[Former Member]

Hello all,

My design studio application goes off Bex query and there are characteristics in the query that are compounded. We pulled in the compounding characteristics to the query and set the display property to "No Display". This takes care of how the data is represented in the resultset. But if you have a dimension filter going off these dimensions, the list of values still shows compounding values. The behavior is also observed when running the query from RSRT.

Is there a way to fix this issue?

BO - 4.1 SP2

DS - 1.4

Thanks

[Former Member]

How about iterating through the members, cutting off the outer compound and inserting those values as text into your drop down?

I Have not tried it in a system but it should be doable that way.

best regards,

victor

[Former Member]

Thanks for the response Victor. It should work, but there are many such filters and many apps and will be a lot of work/rework putting in additional code to pass the selection to other components.

[Former Member]

If you get it working for one object then you can minimize the effort by re-using your code, only variables should be infoObject and drop down name, perhaps you can even create a function for that.