 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point &IBIMR_user not available in edasprof.prf?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point &IBIMR_user not available in edasprof.prf? Read-Only TopicGo | Search | Notify | Tools |
| &IBIMR_user not available in edasprof.prf? | Login/Join |
| Virtuoso |
I have ginned up a filter for MRE users and wanted to place it into the edasprof.prf file. However, it includes a reference to &IBIMR_user and I am getting the feeling that is not allowed. It works fine inside units in the MR repository. Is there a super-secret way to address the MR userid in edasprof.prf, or am I in a can't-get-there-from-here part of WebFOCUS? J.  | ||
|
| Virtuoso |
You might need to add code to the SITE.WFS file in the WebFOCUS Client to pass the value to the WebFOCUS Server. However, for some reason I recall that &variables passed to the WebFOCUS Server are not available to code in the EDASPROF.PRF. What you should do is create a FOCEXEC that contains the code you want to run and then set the _site_profile value in the WebFOCUS Client SITE.WFS file equal to the name of the FOCEXEC. The _site_profile variable is used to force the execution of a FOCEXEC on the WebFOCUS Server when a process starts. This is kind of like a profile focexec. The difference here versus the EDASPROF.PRF is that the &variables passed from the WebFOCUS Client are available for usage. Thanks! Mickey
| |||||
|
| Expert |
I have something like this in our Drive:\ibi\client53\wfc\etc\site.wfs file:
<IFDEF> IBIMR_user
<SENDVAR>
IBIMR_user=&IBIMR_user
<ENDSENDVAR>
<ENDIF>
If the IBIMR_user variable is defined, pass it. I think I needed to do it this way because simply passing the IBIMR_user variable won't work when running a self service program - I think I was getting a major error. 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 | |||
|
| Master |
I dont think any site.wfs vars are accessible in edasprof.prf since the client tends to pop these variables on to the fex submitted which then gets run after edasprof is run This will work with OPSYS authentication. -SET &USERID=GETUSER('A60'); Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Virtuoso |
I will do this -- I was concerned about the self-service issue you raise as well. | |||
|
| Virtuoso |
Huh. Didn't fix it. I added the code just like you show --
<IFDEF> IBIMR_user
<SENDVAR>
IBIMR_user=&IBIMR_user
<ENDSENDVAR>
<ENDIF>
. . . and got the same result. The minute I try to use the &IBIMR_user variable it craps out. It's never quite as easy as it looks. Thanks for the recommendations folks! I'll keep digging. J. | |||
|
| Virtuoso |
Are you trying to use this for a self-service app or for when a user is logged into MRE? Also try the _site_profile setting. As noted in this thread &VARS are not accessible in EDASPROF.PRF. Thanks! Mickey
| |||||
|
| Expert |
I make modifications to site.wfs via the Admin Console - you don't have to restart the server (I think you have to restart the server if you make changes by editing the file). <IFDEF> WORPUSER
<SENDVAR>
UID=&WORPUSER
UPASS=&WORPPASS
IBIC_user=&WORPUSER
<ENDSENDVAR>
<ELSE>
<IFDEF> IBIMR_user
<SENDVAR>
UID=&IBIMR_user
IBIC_user=&IBIMR_user
IBIMR_user=&IBIMR_user
UPASS=&IBIMR_pass
<ENDSENDVAR>
<ELSE>
<SENDVAR>
UID=UNKNOWN
IBIC_user=UNKNOWN
UPASS=UNKNOWN
<ENDSENDVAR>
<ENDIF>
<ENDIF>
I inherited some of the above code, so I don't know if all of it is actually required. I also pass the domain and folder: <set> IBIC_server (pass) <set> IBIMR_domain (pass) <set> IBIMR_folder (pass) <set> MR_BASE_DIR (pass) These can be passed without IFDEF statements. 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 | |||
|
| Virtuoso |
Parameter's being set in the site.wfs are sent to the WFRS as a block of code, and are just -SET &... statements. The problem you are having is that the server profile executes before the block of code from the client is executed. You should consider using the _site_profile to evaluate the IBIMR_user, as it is placed after the -SET's and before the actual procedure to execute. "There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott | |||
|
| Expert |
dh, site.wfs is NOT the site profile? Cheers, 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 | |||
|
| Virtuoso |
Francis, SITE.WFS is used by the WebFOCUS Client. _site_profile is used by the WebFOCUS Server. Thanks! Mickey
| |||||
|
| Expert |
Where is the file "_site_profile" located on the server? 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 | |||
|
| Expert |
Francis, Got to TechSupport, Advanced Search, _site_profile...Tons of stuff... That's what I did, because I too had no idea what Mickey was talking about!!! Thanks! Mickey Tom Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Expert |
I've found four site.wfs files, located in the following folders: Drive:\ibi\client53\home\etc Drive:\ibi\client53\wfs\etc Drive:\ibi\srv53\home\etc Drive:\ibi\srv53\wfs\etc The only file that has anything in it is Drive:\ibi\client53\wfs\etc\site.wfs. I realize that this may have changed for v7.6.5, but why are there so many files? 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 | |||
|
| Virtuoso |
_site_profile is not a physical file. It is a variable. The WebFOCUS Server runs whatever FOCUS code is contained in the _site_profile variable. For example the SITE.WFS would contain a statement such as: _site_profile = -INCLUDE WFSPROF The WebFOCUS Server would then have a focexec called WFSPROF.FEX located somewhere in the APP PATH. It would then execute the WFSPROF focexec after EDASPROF.PRF when the agent starts up. This acts like PROFILE FOCEXEC if you are familiar with this from mainframe FOCUS. Thanks! Mickey
| |||||
|
| Expert |
Yup, I gathered that after posting. Sorry! 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 | |||
|
| Expert |
Francis, The one in home\etc is the one that comes with the software. The one in wfs\etc would be the one you customized for your installation. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Virtuoso |
I found that EDASPROF.PRF is not as usable as I would like. I now use SITE.WFS to SET and PASS &variables and _site_profile to manipulate them. There is also the advantage in self service that you can change _site_profile dynamically within the URL or call form, so having the ability to have multiple 'profiles' depending on the call. Alan. WF 7.705/8.007 | |||
|
| Virtuoso |
I wanted to use this to set a filter on tables so that users would only see their own data. I have it fully implemented in MRE but wanted to move it to the profile to prevent someone from circumventing it. It appears it will not be as straightforward as I thought, but appears to be possible. I'm quite pleasantly surprised at the amount of response I got and how remarkably on-topic the conversation has remained. I'd kill to have a couple of you guys listening in on the I-Way threads. I have to offer free pie to get responses over there. J. | |||
|
| Master |
Interestingly just found that running .fex from apps will pick up vars in site.wfs, but running the same as application from caster will not pick up the variables from site.wfs. You learn something new everyday! Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Platinum Member |
Well the &variable IS named "&IBIMR-USER", isn't it? WIN/2K running WF 7.6.4 Development via DevStudio 7.6.4, MRE, TextEditor. Data is Oracle, MS-SQL. | |||
|
| Virtuoso |
hammo1j, You are learning a bit more of the architecture of WebFOCUS. The SITE.WFS file is only used by the WebFOCUS Client. REPORTCASTER does not go through the WebFOCUS Client to run reports. It talks directly to the WebFOCUS Server. That's why SITE.WFS variables are not available. Thanks! Mickey
| |||||
|
| Virtuoso |
Hey cburtt, Forgive me if I asked you this before but who are you working for in Tarrytown? I went to college at PACE University in Pleasantville. I seem to recall IBM is in Tarry town. Thanks! Mickey
| |||||
|
| Virtuoso |
Forgive me if I asked you this before but who are you working for in Tarrytown? I went to college at PACE University in Pleasantville. I seem to recall IBM is in Tarry town. Hey! Get your own thread! J. | |||
|
| Virtuoso |
Sorry about that. I couldn't resist.  Thanks! Mickey
| |||||
|
| Master |
Yes Caster is a separate java application which like the client talks to the server. However you would expect that running a report under caster would give you the same result as running under the client. Therefore I would say strictly speaking that this is a design flaw and the code in the client to parse site.wfs should be incorporated into caster. Incidentally site.wfs is not read whether you call a proc in MRE or in the Application area. Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point &IBIMR_user not available in edasprof.prf?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point &IBIMR_user not available in edasprof.prf?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |