Can Dashboard identify current user?

[JoergAldinger]

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.

[János_at_SAP]

Hello,

follow this link: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6091ffdd-e1ad-2d10-359f-d644ff7ea...

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

[JoergAldinger]

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.

[daroy_alvin]

Hi,

Try,

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

Thanks & Regards,

Alvin