Skip to Content

Can Dashboard identify current user?

Dear experts:

Is there a way that a Dashboard in B1 can identify the current user, so as to only show "personal" data. Specific case: Salespeople should only be able to see their personal sales funnel, not the consolidated one or the one of other salespeople. I am thinking something along the lines of a $USER variable.

Thanks,

Joerg.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 24, 2015 at 09:51 AM

    Hi,

    Try,


    SELECT T0.[U_NAME] FROM OUSR TO WHERE (T0.UserID = $[USER] OR T0.Internal_K = $[USER])

    Thanks & Regards,

    Alvin

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 24, 2015 at 10:40 AM

    Hello,

    follow this link: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6091ffdd-e1ad-2d10-359f-d644ff7eaa4e?overridelayout=t…

    I am not sure that the internal $[USER] parameter is recognized when you executing queries via dashboards, but you can try it.

    Thanks,

    János

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for your suggestions. But the $[USER] parameter will not work because the query is actually executed by B1i, not by the B1 client.

      I have traced the variable replacement in B1i down to the following atom:

      /B1iXcellerator/exec/dummy/com.sap.b1i.vplatform.scenarios.design/vBIU.sap.XcelSelectGet/atom1.xsl

      However, it only replaces %0, %1, etc. , there is nothing like a "user" variable. Nonetheless, it should be possible because B1i does have information about the user's session, and that includes the user name that is sent from B1 during logon to B1i Xcelsius package. Modifying atom1.xsl should enable this without too much trouble, except for when upgrades are due.

      Since everything is moving to HANA and HTML5 and nobody seems to be dedicating any resources to BusinessObjects Dashboards in B1, I have given up on using BO Dashboards and implemented a HTML5 dashboard using PHP, and then passing in the user ID through a URL parameter to the PHP script. Much easier to maintain in my opinion, and seems to be faster, too.

      Thanks,

      Joerg.