Skip to Content
0
Jan 05, 2023 at 10:35 AM

Value filters in SAP Analytics Cloud

444 Views Last edit Jan 05, 2023 at 10:42 AM 4 rev

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....