Hi Eric,
Can you provide screenshots of the following?:
1) The initial view of the BEx Query data source you are using to populate the Dropdown, showing the key and text values of the dimension members to be used for filtering;
2) The initial view of the Universe data source showing the key and text values of the dimension "_RogQIRwAEeiofrGGUX0vqg".
You need to make sure that the format of the key values from the BEx Query match the format of the corresponding Universe dimension values.
Also, how are you populating the Dropdown Box?
Regards,
Mustafa.
Hi Eric,
I suggest you change your code as follows:
//set filter on universe DS_1.setFilterExt(<Technical ID of BA_Key>,DROPDOWN_1.getSelectedValue());
Regards,
Mustafa.
BEX Query initial View
Universe Initial View
Business Area (City) in the BEX Query corresponds to the BA_Key (City) in the universe.
The items For DROPDOWN_1 get loaded via the following code during the application's "On Startup" event.
DS2.loadDataSource(); DS2.setVariableValueExt("ZA_BUSAR",exclusion); DS2.setVariableValueExt("ZFYR_MULTI_REQ","2016;2017;2018"); DROPDOWN_1.setItems(DS2.getMemberList("0BUS_AREA", MemberPresentation.EXTERNAL_KEY, MemberDisplay.KEY_TEXT, 1000)); DROPDOWN_1.sort();
Add comment