Passing BOUSER variable as a parameter to a DB2 stored procedure

[Former Member]

Hi,

We have created a stored procedure in DB2, which accepts five parameters. We have to pass the userrname of the logged-in user as one of the five parameters. We have created a DeskI report based on this stored procedure and we have used @variable('BOUSER') as the value for the concerned parameter.

But Business Objects passes the string '@variable('BOUSER')' as it is instead of replace the variable with it's value. Does anybody have any idea on passing BO variables as parameters to a report based on stored procedure?

[Former Member]

hi,

Create an object called 'user' with the following definition

select:

username

where:

username =@Variable('BOUSER')

Use this object 'user' as parameter to the storedprocedure.

Regards,

Vamsee

[Former Member]

Hey, thanks for the reply.

Can you elaborate on the steps to use this object 'user' as parameter to the storedprocedure.

Thanks in adavnce.