Hi All,
Initial Problem: ClearAllFilters() and removeSelection() not working
Requirement: Need a reset button to bring dashboard tot he initial state.
Procedure followed: I am using multiple Drop downs to filter data before bringing it into the application because of the huge volume of the data.
1) My application contains few drop downs, crosstab, and Button(Reset).
2) CrossTab : Changed the User Interactivity options. Selection Type=Single, Selectable Area =Rows.
CrossTab works like a Drilldown in Webi report, because of the Java Script.
Example Drill Down: Country-->State-->City-->Store
For Drill down functionality, created a vaiable "Level" and assigned it as "Country"
Cross Tab On Selec Code:
if (level == "Country " ) {
level = "State";
DS_1.setFilter("0COUNTRY", CROSSTAB_1.getSelectedMember("0COUNTRY"));
DS_1.removeDimension("0COUNTRY");
DS_1.moveDimensionToRows("0STATE");
}
else if (level == "State" ) {
level = "City";
DS_1.setFilter("0STATE", CROSSTAB_1.getSelectedMember("0STATE"));
DS_1.removeDimension("0STATE");
DS_1.moveDimensionToRows("0CITY");
}
Else{ if (level == "City" ) {
level = "Store";
DS_1.setFilter("0CITY ", CROSSTAB_1.getSelectedMember("0CITY "));
DS_1.removeDimension("0CITY ");
DS_1.moveDimensionToRows("0STORE");
}
}
3) Reset Button Code:
DS_1.ClearAllFilters();
CROSSTAB_1.removeSelection();
My issue is, when user click on reset button, the application need to reload or refresh(Clear all filters).
Ex: When the CrossTab in the Region selection, if user clicks reset button the cross tab need to go back to its initial stage i.e Country
I am using ClearAllFilters to clear the filters, and RemoveSelection function, but the crosstab not going back to initial stage.
Ex: When user left the CrossTab at State Drilldown/navigation, and clicked the Reset button, its clearing all filters but the cross tab remains in the same state.
Reset Button Code:
DS_1.ClearAllFilters();
CROSSTAB_1.removeSelection();
Is there a way to reset the crosstab? Any workaround?
Note: I tried searching SCN but didnt find similar issues:
Tried DS_1.moveDimensionToRows("Country"); , DS_1.moveDimensionToColumns("Country"); but it didn't work.