Focal Point
[SOLVED] User name displayed on the Reporting server console

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2937004436

October 29, 2013, 09:55 AM
<Gilles>
[SOLVED] User name displayed on the Reporting server console
The reporting server uses &IBIC_user for deferred reports, so does Report Caster.
I would like to see which MRE user is using the Reporting server sessions for a better control and service.
I cannot set &IBIC_user=&IBIMR_user for the above reasons, but is there anyway the Reporting server USER column could show the MRE user when the &IBIC_user is null.
Thanks for your help.

This message has been edited. Last edited by: <Kathryn Henning>,
October 29, 2013, 12:00 PM
Francis Mariani
Gilles,

Add the MR User parameter to the Admin Console Custom Settings (site.wfs). Please see this post. The variable will be available to all fexes, though probably not to ReportCaster.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 29, 2013, 12:50 PM
<Gilles>
&IBI_user and &IBIMR_USER are already in the site file. The point is that the REPORTING SERVER CONSOLE displays &IBI_user only in the USER column and I would like to see &IBIMR_user as well.
Thanks for your help.
October 29, 2013, 04:51 PM
Francis Mariani
Sorry, I didn't understand what I read. If you mean the Data Services Agents (Workspace) area of the Reporting Server Console, I'm not sure if there's anything you can do. I clicked on "Choose Columns" to see if another user-related column is available but I couldn't find one.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 30, 2013, 08:55 AM
Craig Thummel
Here's one way;

Configure WebFOCUS Reporting Server for trusted connection;
-From the Reporting Server Console choose “Workspace”; “Access Control” then “Others”.
-For the “trust_ext” setting, choose the “Y” radio button.

Configure the trusted connection from the WebFOCUS Client to the Reporting Server;
-In the WebFOCUS Administration Console select “Reporting Servers” then “Remote Services”.
-Select the “Node Name” radio button that you would like to configure the trusted connection to and then choose “Modify”.
-From the “Security” section, choose “Trusted”
-Select the “WebFOCUS script variable” and enter the value “IBIMR_user”. This will pass the MRE ID being used to the WFRS. However, a security person I spoke with at IBI suggested using REMOTE_USER in the “Web server HTTP variable” option but due to a bug in 7.6.11 we had to us WF_REMOTE_USER in the “WebFOCUS script variable” option. One of these options ought to work.
October 30, 2013, 09:46 AM
<Gilles>
Hi Craig,
“WebFOCUS script variable” and enter the value “IBIMR_user” did the job perfectly on 7.7_05.
This way I get the MRE and Report Caster user name displayed.
Thanks very much for your help and time.