Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Hi Rahul did you ever solve this issue? We have the same requirements where we also are avoiding using universes as it was our strategic direction to connect WebI and Lumira directly to HANA 2.0 calculation views without a universe.

  • Follow
  • Get RSS Feed

0 Answers