Skip to Content
0
Aug 10, 2018 at 10:25 PM

Pass BOUSER(or session user) to HANA Calc View using HANA Direct/Live connectivity

393 Views

We have multiple HANA calc views which are accessed by Webi users using HANA direct connection to create reports. The connection uses a named user credentials and the webi users are not present in HANA system.

How can we pass BO Session User ID info to these calc views to filter the data based on the user logged in (one of the HANA tables has a user ID field). May be at connection level or a dynamic sql in proc?

Do not want to go in unx route (@Variable(BOUSER)) or creating a 2nd query at report level which will be an additional step for end users.