Skip to Content

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

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 !

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Feb 03, 2017 at 10:37 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 12:29 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 01:00 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 01:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 02:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded