Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dynamically change reporting servers

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] dynamically change reporting servers
 Login/Join
 
Member
posted
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
 
Posts: 12 | Registered: July 11, 2016Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Expert
posted Hide Post
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...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: July 11, 2016Report This Post
Expert
posted Hide Post
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...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: July 11, 2016Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: July 11, 2016Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
No worries thank you for your suggestions!


WebFOCUS 8
Windows, All Outputs
 
Posts: 12 | Registered: July 11, 2016Report This Post
Guru
posted Hide Post
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.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dynamically change reporting servers

Copyright © 1996-2020 Information Builders