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

[Paul1202]

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 !

[Paul1202]

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

[Paul1202]

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

[amitrathi239]

What are you going to do with get the username?

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

[amitrathi239]

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

[Paul1202]

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.

[amitrathi239]

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