Hi Adem,
Due to the way cascading filters work, for your requirement you need to create two separate data sources assigned to the SAME Universe. The steps are as follows:
1. Create a duplicate of your data source DATA_SALES_UNIT_MTD and call it DATA_SALES_UNIT_MTD_FILTERED;
2. In the data source initial view for DATA_SALES_UNIT_MTD_FILTERED, place the "_wVTG0HHZEeeYI-Qg6aRcTA" dimension in the Rows panel and set the Members for Filtering setting to "Only Values with Posted Data";
3. Bind the Items property of RADIOBUTTON_FIL_YEAR where:
Source Data Source = DATA_SALES_UNIT_MTD
Source Dimension = _wVTG0HHZEeeYI-Qg6aRcTA
Follow Filter State = true
Target Data Source = DATA_SALES_UNIT_MTD_FILTERED
Target Dimension = wVTG0HHZEeeYI-Qg6aRcTA
4. Bind the Items property of Checkbox Group CBG_VERSION where:
Source Data Source = DATA_SALES_UNIT_MTD
Source Dimension = VERSION_DIM
Follow Filter State = false
5. In the "On Select" event of Radio Button Group RADIOBUTTON_FIL_YEAR apply the following script code:
var mySelection = DATA_SALES_UNIT_MTD_FILTERED.getMembers("VERSION_DIM",100); var mySelectedBudgetVersions = [""]; mySelectedBudgetVersions.pop(); mySelection.forEach(function(element, index) { mySelectedBudgetVersions.push(element.internalKey); }); CBG_VERSION.setSelectedValues(mySelectedBudgetVersions);
Regards,
Mustafa.
Hi Adem,
I suspect the same behavior. Please see below screenshot:-
I tried few tricks before i could make up my mind and make a change at query level (Bex-Query Designer). Both below tricks didn't work, therefore i applied filter at bex level, since my requirement is different and i can live with those query hard-coded filters for now.
Possible Fix?
Try creating a variable for "Date Object" and then use DS_1.setVariableValueExt(variable, value).
This will submit back the query and execute it again.
Regards,
Fahad
Hi Adem,
do you set "only values with posted data" for the dimension "VERSION_DIM" in the Initial View?
regards,
Giulia
Add comment