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,

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....

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.

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!

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 ?

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.

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

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)

Hi,

I tried the site_profile but that didn't seem to work.
Trying other options at this point.

Thanks!

kpfliger

I went back an tried myself with no luck. Sorry I was not able to help.

No worries thank you for your suggestions!

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.