In this example ‘Country’ is the dimension, France and the UK are the dimension members we want to filter on
Apply a Filter with a multiple hardcoded dimension member values Read More »
This code explicitly references the dimension ID and Description, this prevents the need for a data source query to be triggered.
Apply a dimension filter using a dropdown list without triggering a data source query Read More »
In this code example you would have a dropdown list and a table.You want to filter the table ‘Sales Manager’ dimension using the dropdown list
In more complex SAC stories there can be many interdependencies and interactions between widgets.This code takes a single dimension filter value and sets it as the selected key in a dropdown.
Users will commonly want to be able to filter on specific values or all values from a dropdown list,unless specific requirements deem this unnecessary, I always add an ‘ All ‘ value to dropdowns. When we look at filtering with dropdowns, we can use the ‘All’ value to remove the dimension filter.
Adding the ‘All’ value to a dropdown Read More »
