OBIEE: Gotcha #2

This one bit me hard today and it shouldn't have. I should have followed my instincts...instead I trusted the tool. ID10T.

So here we go.

We use the Filters in the Security tool which can apply predicates based on the Group.

First, open up the Security Manager



You should see this


Then click on Permissions


I then, like an ID10T used the Expression Builder to build my predicate. This was a BETWEEN, so I went to Operators and found the BETWEEN and double clicked on it. Can you see what it did?


How about now?


That's right, it says "Upper Bound" first followed by "Lower Bound"

I knew that wasn't right...but I went with it anyway.

After the "mistake", I verified in SQL.

SQL>EXEC :C := 20;

PL/SQL procedure successfully completed.


         C
----------
        20

SQL>SELECT * FROM DUAL WHERE :C BETWEEN 40 AND 10;

no rows selected

Elapsed: 00:00:00.18
SQL>SELECT * FROM DUAL WHERE :C BETWEEN 10 AND 40;

D
-
X

1 row selected.

Live and learn I guess. I'll never trust that thing again. One more reason to dislike GUIs.