Decrypt data in Web intelligence report

[Former Member]

Hello,

We are trying to decrypt the data in web intelligence report. There is an encrypted data column that needs to be decrypted. Please suggest an option to decrypt the data in run time or when report is refreshed or any other alternative...

Appreciate the response. Thanks and looking forward to suggestions.

Regards,

Mohammad

[Former Member]

Hello Mohammed, did you get any update on the same?

How did you decrypt the data in BO at the universe OR report level? I am looking for the similar solution. could you help?

[manikandan_elumalai]

You definitely need the encryption and decryption logic in order to achieve this.. I would suggest you to build the decryption logic at database level as function and make use of it in object definition in universe level.

Thanks

Mani

[Former Member]

Hi Mani,

Function being used before data is loaded in database is

publicstring Encrypt'FIELD'(string 'FIELD'){returnthis.EncryptStringAES('FIELD);}

Now, in Universe object definition,

modifying the sql expression using the function ....Decrypt'FIELD'...would yield to intended result?

If there is an additional need of 'PlainText' or 'Ciphertext' etc.. I can try that as well.

Thank You,

Mohammad