Search This Blog

Saturday, August 20, 2011

How to display the user and usergroup who logged in to the dashboard page?

Using session variables we can display the user and usergroup values on dashboard page.
1. Drop Prod_Name thrice on the report window, rename the second column to USER and 3rd column to GROUP.
2. In Edit column formula of the USER column add the following expression and hide the column.
VALUEOF(NQ_SESSION.USER)
3. In Edit column formula of the GROUP column add the following expression and hide the column.
VALUEOF(NQ_SESSION.GROUP)
4. Create a Narrative view
Here @2 points to the second column value, @3 points to the third column value on the report.
Create a Dashboard page with the above report.




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.