Tuesday, March 30, 2010

Cookies in OBIEE

I had a requirement to do some sort "hand-shaking" between OBIEE and APEX for security purposes: basically I had to read a session variable that was set by APEX then set a cookie using that session variable avlue. As many bloggers pointed it out a lot can be done using javascript in OBIEE. This posting gives a very simple example.

First I set the values of apex_biee_key in the rpd using a simple query (in our set up this value is set by the apex application).

Initialization block to populate apex_biee_key

Javascript for reading apex_biee_key session variable and setting a cookie with the same name: APEX_BIEE_KEY

Create an html report with the javascript code:

that's it your cookie is set