Filtering Data according to the User 1

[dideb]

Hello all,

I need to create a report that needs to be filtered according to the user logged in.
i.e each Field Supervisor sees his own data, each manager sees the data of his Field Supervisors, etc.

This is needed to be done on the report level.
I have written an SQL that returns a result set containing the names of Supervisors belonging to the User loging in.
The problem is that i can't pass the User loged in to the SQL.
Does any one knows how? or even knows how to do this in another way?


Thank you,
Diaa

 

[skrandel]

This can only be done if the reports are accessed via full-client. But, you'll still need to have a user id that matches the BO login returned by the report.

The problem is that you can't do it with InfoView. Security you are talking about really requires that reports are refreshed.

You made a comment that is interested. "The problem is that i can't pass the User loged in to the SQL." Business Objects ALWAYS knows who the logged in user is. @Variable('BOUSER')is always passed to the database.

Steve Krandel
VERITAS Software

 

[dideb]

Hello skrandel,

Thank you a lot for your reply.
The question i wanted to ask now is:
Is "@Variable('BOUSER')" a reserved expression that can be used in the SQL of the report?
Also, which user will this variable return: the user in the supervisor or the user in the connection to the BO repository?


Thank you,

Diaa

 

[skrandel]

Yes, it's a reserved expression. BOUSER is the name of the variable that returns the name of the user (from Supervisor).

Steve Krandel
VERITAS Software