Skip to Content
0

Apply Filter on a measure variable SAP BO

Apr 13 at 12:11 PM

34

avatar image

Hi all,

I'm trying to apply a filter on a measure variable and it doesn't work, not even applying Sort or Ranking. This variable was created based on the results of "original" measures. Do you know how can I solve this?

I'm using SAP BusinessObjects BI Platform 4.1 Support Pack 6 Patch 3

Version: 14.1.6.1805.

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Apr 13 at 12:41 PM
0

try to create dimension variable and see or share the screen shots of your issue

Show 12 Share
10 |10000 characters needed characters left characters exceeded

When I change this variable to a "dimension" and I try to apply a filter with the option "in list", for instance, the list doesn't have all the values that the variable has.

0
Patrícia Costa

can you share the data screenshot and variable details.

0

This is my variable:

This is what appears when I try to aplly a filter:

variable.jpg (59.7 kB)
test1.jpg (50.1 kB)
0
Patrícia Costa

Drag this variable in the table and see if you are getting Yes/No values in the rows?

0

Yes, I'm getting:

test2.jpg (61.5 kB)
0
Patrícia Costa

Type the value "Yes" in the type a value block in the filter and drag other side. see if it will work

0

I've tried this before and, unfortunately this is what appears :

test3.jpg (80.0 kB)
0
Patrícia Costa

it's difficultly to say..might be some measure objects are with delegated measures type in BEx. instead of "Yes" or "No" use 1 or 0 in the formula and try.

0

It's the same.

All in all, can I apply a filter on a measure? :S

0
you cannot apply filter on measure.

0
Jawahar Konduru

Report level filter can be applied on dimension/measure/detail.There is no restrcition.

1

Someone told me that the problem can be caused by the fact that these numbers are not all in the same unit in the database (some are in kg, others in m and others in un), is that true? If yes, how can I overtake this problem?

0