Hi,
I have a question and it might be an obvious answer or it might not be and its to do with filtering data.
After years of using SAC something like this creeps into a requirement and I always struggle with it and I would like to know the correct way to perform this task…..
The scenario…over simplified….
I have a new model with the following data in it
Business Product Volume BHL 3CX 4 BHL 4CX 10 LDL X47 19 LDL X97 13
What is the correct way to return data from this model WHERE Volume > 10 AND Volume < 20 ?
Baring in mind there could be millions of rows in the dataset and I just want to use a slider to select a range of volume between two values?
I have seen a previous post on using a measure based dimension but I can see from this that it just presents the user with select members in the filters - it does not allow for a range probably because it assumes its text.
What is the text book way to return this sample via a filter?
Any help appreciated as always....