Java script in OBIEE

Question

Hello All,

I am trying to write a function in java script and add it to the "common.js"  file in obiee. I will be calling this function in a new dashboard that I will be creating. My DBA is not big on this idea as he says that whenever a patch is applied the changes made to "common.js" will be over written . So he wants me to find another way to implement this.

My question is "Is there a way that i can write a javascript function within the dashboard"?

Any advice much appreciated.

rmoff · Answer

+1 to @Gianni Ceresa. JS for encryption in the front end ... wat. Unless you mean obfuscation, and you want to translate the value, but don't care if someone else can too. This kind of data work you should be doing in the database.

Gianni Ceresa · Answer

Sorry but ...

Why to make it so complicated?

I would say you have to store the decrypted value in your DB and just setup a correct security in your DB > RPD > OBIEE objects so that only authorized users can access it.

The OBIEE front-end is not a simple table with just few rows and columns, because of all the possible interactions it is a complex structure, so just the work to parse your page and identify the cust_id column and get it's values to then call your webservice and replace the value ... That's lot of work for your browser and, assuming you have more than just few cust_id per page, it will soon get really slow and not really userfriendly...

So setting up a good security and storing the values in the DB is as secured (if not more) than calling your webservice etc.

user11921531 · Answer

I think i should have stated my actual requirement earlier ,

I have a cust_id column in a report. The cust_id column is encrypted.I need to de-crypt the cust_id column before its displayed on the report. The javascript that i have makes a call to a web service which decrypts the cust_id . I am trying to see how i can implement this.