Skip to Content
0
Sep 14, 2011 at 02:12 AM

How to do "OR" logic in a Bex global filter variable?

466 Views

Hi,

Bex 7.2

The requirement for Bex global filtering is:

If prompt answer is blank

display all data in cube (this is standard functionality)

else

display (all dates which are GREATER THAN prompt date

OR

all dates which are blank)

end if.

I've tried one user input variable but the query saves with errors.

Also tried one user input variable with a user exit variable - filtering is not applied.

Any suggestions appreciated.

Thanks!