Skip to Content
0
Former Member
Aug 30, 2012 at 04:58 AM

BOUSER In Universe connection

128 Views

Hi All,

We have Implemented the BOUSER Variable in the END_SQL Parameter Of universe to fetch the BOXI Users who are running the Reports SQL in the database by looking at the query.

However at times the User use the Custom Sql functionality of the Webi and that By passes the Universe Parameters and the User is not fetched in the SQL.

what I think is while using the custom sql the universe Connection will still be used , My question is can we Put some parameters in the connection like Something in connectinit or Hint .( we are using oracle) to fetch the details of the boxi user

Also , we have to keep the Rights For Custom SQL and edit query for users as this is business Requirement.

BO XI 3.1 SP 2

Thanks