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](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3zSG3nWnQjfA067tecAa-wwM1umPvoIbkqgVlnPhcdiEvZYnnOPLIksDgKdy-xfu8vO1pbSaGxNpzyfQkXh2kz3s5N0GZ9_pDg7nfbznu21DRYZEmUntM3A4Axg7dSSayJZzj8A98mQxQ/s800/01_OBIEE_GOTCH_2.png)
You should see this
![security](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjizWIVW9VkY-qGl-_EdGjB8bRvNqnQhdSuPXr1Y6PgEFR4q2k8cbo92bYc0L5E8F23OVzhCV-7hub6JtFR17Ewksdb7cWh5R8aMmJhviMSKV1AFCddBpxeGzbF_2EOKYuSc4lKHdMGrG0/s800/02_OBIEE_GOTCHA_2.png)
Then click on Permissions
![security](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRctqaq8Fa6of5V7mcMiGv3RtxxyGe1aw3KKWg_NUy2OImE7CKm7Tvjhpt6FqVAx-96tajkEdeTa_MF08XTwEIjXJ2BTY6NQccLOuuSIFteGZN3KWoiVGHzk3iJuS5Bh9ZF31Jc4uzW0x-/s800/03_OBIEE_GOTCHA_2.png)
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](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSrrd9MWqoBF_hcx1JybTYsYvrBP1raa_isUV2XbuH09qeAVPCE-PGKEmSKE2IJNuMhXCSWQdjjLcLn4lo6vWG1TCklPXyJT2Seq5siP0NRSLyfxa_vOG22BEjqEn0YFLuoAaOvHpm70i2/s800/04_OBIEE_GOTCHA_2.png)
How about now?
![security](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVhHJiyThQLtugXm48m4rtMHUpM_d7os3lEhdiTg4HB8SXnp7YEW2L1J-h_pXzcV-uj_RMn-Rw8GMiyqnYtjpOXbh439YOUBhPk0Xzu-ulRRhm2q5w62YuuYHiX9p763svBGLx4OK6ErJR/s800/05_OBIEE_GOTCHA_2.png)
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;Live and learn I guess. I'll never trust that thing again. One more reason to dislike GUIs.
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.
3 comments:
Keeps you on your toes. Think of it as a reverse Easter egg :0)
Tim,
That's just too weird...I was just reading your post on the BI Publisher Excel templates. Are you stalking me? :)
File a bug man!
Post a Comment