Select @user onLoad for a pager?

Unknown

I'm building a timetracking tool and have a pager by employee. As each employee will be entering their own time, I would like the pager to auto-magically default to the current user. With that feature, whenever someone opens the timesheet, it will be showing their own timesheet.

 

We will have security limiting which other users they will be able to see, but for right now, I need help figuring out how to default the pager to the logged-in employee (@user).

 

Any ideas?

 

Thanks for your help

Alexander Kappes

Dear Bob Gill,

 

I think the only way for you will be inserting custom selection script into your database Security profiles which looks like:

 

Select Entity = @User

 

Only thing you have to check is that the Usernames in the entity are the same like the login Accounts.

 

Hope it helps.

 

regards

 

Alexander Kappes

Nicolas CHIGROS

I done this myself for a project and it works. You may do it differently if you have the "~db"  security option at your disposal.

 

By the way, this lead me to post that idea :

user session & user stored cubes to help with user experience