Thursday, May 20, 2010

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

security

You should see this
security

Then click on Permissions
security

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?
security

How about now?
security

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.

3 comments:

Tim dexter said...

Keeps you on your toes. Think of it as a reverse Easter egg :0)

oraclenerd said...

Tim,

That's just too weird...I was just reading your post on the BI Publisher Excel templates. Are you stalking me? :)

Tom said...

File a bug man!