call from an Object from a universe.

sdk development
1

Hi , I am new to BO SDK and trying understand if we can make java calls from with in an object in the universe. For example:- Let me take SSN number.
SSN number will be in an encrypted for format in the database.
The BO WEBI reports (both Adhoc and canned) that contain the SSN object should be able to make decryption calls and show the decrypted SSN number.

Appreciate any help and suggestions . This is driving us crazy !!!

Regards
Raj.

new_bo (BOB member since 2006-10-25)

2

The universe is used to construct SQL, which is executed against the database. There are a few placeholder values that can be plugged into the SQL, such as the current user name, but there’s no way to call a custom function on a database value.

I’d suggest you look into the possibility of calling your function from within the database. That is, create a database function that in turn calls your decryption method. Then the SQL in the universe would just need to call the database function.

joepeters :us: (BOB member since 2002-08-29)

3

The Decryption function is not a database function, It is HP voltage decryption method. HP voltage will be hosted on a different server. If not on the universe side can we do anything on WEBI Client

new_bo (BOB member since 2006-10-25)