Apply a dimension filter using a dropdown list without triggering a data source query

This code explicitly references the dimension ID and Description, this prevents the need for a data source query to be triggered.

var DS =Table_1.getDataSource();
var memberId = this.getSelectedKey();
var memberDescription = this.getSelectedText();
DS.removeDimensionFilter(memberId);
DS.setDimensionFilter(“Sales_Manager”, {id: memberId, description: memberDescription});

var DS =Table_1.getDataSource();
var memberId = this.getSelectedKey();
var memberDescription = this.getSelectedText();
DS.removeDimensionFilter(memberId);
DS.setDimensionFilter("Sales_Manager", {id: memberId, description: memberDescription});

Code language: JavaScript (javascript)

bACK