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:
