Skip to Content
0

Using @Variable('BOUSER') in an MDX unv-universe

Feb 03, 2017 at 10:26 AM

45

avatar image

has anybody any idea if it is possible to create an object in a SAP-BW based unv-universe (so MDX), which would return the logged-in user when using it in a WEBI-report ?

Or any kind of alternative solution ?

Thanks a lot !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

AMIT KUMAR
Feb 03, 2017 at 10:37 AM
0

use =CurrentUser() function in webi to get the logged in user name in webi report.

Share
10 |10000 characters needed characters left characters exceeded
E. Ocula Feb 03, 2017 at 12:29 PM
0

Hmm. That would work in normal circumstances. But :

in this report we are merging data from SAP-BW with data from an XLS.

And we would like the restrict the data through the query, not in the report-blocks. Else the merging will be over the whole data-set. Means it will not work.

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 03, 2017 at 01:00 PM
0

have you enabled the SSO in the universe connection.data authorization in Webi will handle by enabling SSO in the universe connection.

Share
10 |10000 characters needed characters left characters exceeded
E. Ocula Feb 03, 2017 at 01:50 PM
0

Hi,

I was thinking on this as well. But we have a fixed/dedicated user in use in the universe-connection to SAP-BW. This for various reasons.

But even if we would have SSO, I'm not sure whether it can help us. As I do not know if in the BEx-query on BW, they can make an object in the BEX-query which would result in the name of the BOUSER

Show 1 Share
10 |10000 characters needed characters left characters exceeded

What are you going to do with get the username?

Your requirement is to apply the data authorization or something else?

0
E. Ocula Feb 03, 2017 at 02:41 PM
0

Let me explain

  1. Query-1 : data from SAP-BW, with Manager-names
  2. Query -2 : data from an XLS,, with the same manager-names, and the employees reporting to these managers, and some KPI's of these employees

In the WEBI-Doc, we are merging the Manager-names between the 2 queries

What we want to achieve in the report, is : when a manager logs in in BI 4, he/she opens the WEBI-doc, and he/she should see a list, in an input control, of all employees of his/her group. When selecting one or more of his employees, he/she should see the list of KPI's of the/these employees

So we want to restrict the data the manager sees, based on the BOUSER variable. We have the same content of that BOUSER as well in the data retrieved from Query-1 (or Query-2), let's say "Manager User-ID"

In a relational universe, it's simple.

  1. You make an object, let's say "Manager login" in the universe. so with syntax : @Variable('BOUSER')
  2. In the Query-panel of the WEBI-Doc, under the query-filters, you choose : "Manager User-ID" equal to "Manager login"

This way the data retrieved will be only for the manager logged in

But in a SAP-BW universe (.unv) it is not possible to make such an object with @Variable('BOUSER') .

So I'm looking for a possible alternative

Many thanks for your help already

Share
10 |10000 characters needed characters left characters exceeded