I have a group of about 29 users who would like to view thei...

[Michael Williams 11]

So, usually this depends on the setup of your organization, but check if &FOCSECUSER corresponds to your user ID.

[Casey Green]

I have a group of about 29 users who would like to view their daily sales metrics in a report. I have everyones information and can filter on an individual sales rep by selecting his or her employee ID in the report filter. However, I want the reports to default to filter on the employee ID based on the users login ID (mostly so that the sales reps cant access other reps report numbers).

Is there a way that anyone knows of to pass a users login account ID as a parameter within a report

Thanks

[Matthew Carey]

We use &IBIMR_user within reports/dashboards to get the user name of the rep who is logged in. We can then query a permissions table with the user name to get their rep number, region, division etc. and apply them as filters.

[Jan Vostr]

Same as @matthew.carey .

I use

IBIMR_user(pass) in global variables - Administration console -> Custom settings. Works like a charm.

[Manoj Chaurasia]

Casey

Jans response is correct but for some reason myibi cuts of html syntax so you need the word SET surrounded by carets < > before the IBIMR_user in your custom settings. You can also set up a trusted connection between the WebFOCUS client and reporting server which will also send the &IBIMR_user or &FOCSECUSER. To do that your admiistrator will have to use the client administration console under Configuratioln / Reporting Servers / Server Connections / EDASERVE and choose Trusted under the Security

 

image.png930470 33.4 KB

 

Then on the Reporting Server Console under Access Control right mouse click on the Primary Security Provider and choose Properties and then change the trust_ext from N to Y and save

 

image.png800585 33.3 KB

[Casey Green]

Boom, thats it. Thanks!

[Casey Green]

This was also exceptionally helpful. Thank you so much Chuck!

[Casey Green]

So Ive run into a hurdle. It looks like &FOCSECUSER is returning the user ID but it is only successfully being passed through when the user has admin priviledges. Ive made sure that the connection between WebFocus and the reporting server is trusted and is passing the user ID and their groups but &FOCSECUSER still seems to not be returning anything. Is there a permissions setting that Im missing to allow &FOCSECUSER to be passed to any user

[Casey Green]

This issue has been solved. It looks like the usernames for the admin accounts (the ones I was testing with) have a different prefix than the everyday user. I was substringing &FOCSECUSER to remove the prefix but it was removing the entire string for non-admin users!