 |
|||||
|
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 [CLOSED] dynamically change reporting servers
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynamically change reporting servers Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] dynamically change reporting servers | Login/Join |
| Member |
Hi, We are running Webfocus 8205 and I'm looking for a way to dynamically choose a reporting server for our master files. For Example: We have customer A, he needs to run reports and use master files on reporting server A. Customer B needs to be able to run the same report but use master files from Reporting Server B. Please let me know if anyone has any suggestions on how to accomplish this or if it's even possible. Thanks!This message has been edited. Last edited by: FP Mod Chuck, WebFOCUS 8 Windows, All Outputs | ||
|
| Virtuoso |
kpfliger If customer a and customer b use different WebFOCUS domains to run their reports from then you can simply change the server properties for the domain to use a different server. You can do this at the domain level down to the report level. Right mouse click on the domain and choose properties and then there is a tab that says Server where you can choose which server to use. There are other ways but this is the easiest.... Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Expert |
If you mean that you have two WebFOCUS reporting servers, you can select the reporting server with the IBIC_server parameter. This requires the reporting servers to be defined in the client. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Hi, Yes, Waz we have 2 Webfocus reporting servers,knowing that how would we setup the IBIC_server parameter to change dynamically at runtime? Could we set that somehow in a procedure? Thanks! WebFOCUS 8 Windows, All Outputs | |||
|
| Expert |
No, once you get to a procedure you are already on the reporting server. Unless you have an HTML page you are generating, etc How are the procedures run ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
kpfliger My untested thought on this is to create a _site_profile fex that looks up the customer in a table to determine which reporting server to use and then set the &IBIC_server parameter accordingly. This site profile gets run prior to the report fex and should direct it to the proper reporting server. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Member |
Hi, It looks like we could possibly set the IBIC_server value Custom Setting in the Admin console. However the code at is in there today does not look like WebFocus code. So 2 questions to the group: 1. Can we use -Set and -If checks in the Custom Settings? 2. If we can not use -set and -If checks what would the syntax look like to do if checks to set the IBIC_server value to the value needed based on the member? Below is what we currently have in our Admin Configuration>Custom Settings box: # Copyright 1996-2011 Information Builders, Inc. All rights reserved. # $Revision: 1.7 $ # place any variables here from cgivars.wfs that you wish to override. WF_APP_POST=IBFS:/WFC/Repository/Resources/Hidden_Content/Config/Post_Process.fex WebFOCUS 8 Windows, All Outputs | |||
|
| Virtuoso |
kpfliger You can't dynamically set the IBIC_server in the custom settings it can be a static setting. That is why I suggested using the _site_profile fex. If you want to set a static value here is the syntax. <SET> IBIC_server=EDASERVE(PASS) Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Member |
Hi, I tried the site_profile but that didn't seem to work. Trying other options at this point. Thanks! WebFOCUS 8 Windows, All Outputs | |||
|
| Virtuoso |
kpfliger I went back an tried myself with no luck. Sorry I was not able to help. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Member |
No worries thank you for your suggestions! WebFOCUS 8 Windows, All Outputs | |||
|
| Guru |
Not an optimal solution, but it works if you really need it and if the reporting servers can be connected to each other. You could create a external reporting server adapter on each reporting server and then set the right masterfiles / adapter in the user / group profile. Test: WF 8.2 Prod: WF 8.2 DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynamically change reporting servers
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] dynamically change reporting serversCopyright © 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 |