Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] dynamically change reporting servers
Go
New
Search
Notify
Tools
Reply
  
[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, 2016Reply With QuoteReport 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: 2003 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport 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: 6292 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport 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, 2016Reply With QuoteReport 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: 6292 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport 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: 2003 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport 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, 2016Reply With QuoteReport 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: 2003 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport 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, 2016Reply With QuoteReport 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: 2003 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
No worries thank you for your suggestions!


WebFOCUS 8
Windows, All Outputs
 
Posts: 12 | Registered: July 11, 2016Reply With QuoteReport 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: 441 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.