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