Redirecting reports to Server Group

We have created some new server groups with WebI processing servers for fast processing (idle connection timeout of 1 minute) of Xcelsius LiveOffice objects. All Xcelsius related LO connections are being redirected to this server group. However, there are 200+ other universe based Crystal reports in our system that make a call to the WebI processing server for prompts and SQL generation. We would like these other reports to NOT go to the Server Group created for processing of Xccelsius WebI documents. 2 questions:

  1. Is there a way to tell a set of reports NOT to use a server group?

  2. If I create another Server Group for these set of reports, is there an easier way to redirect all requests for these reports to this new Server Group rather than doing it via tedious report by report Default Settings option?

Thanks.


Farhan Jaffery :us: (BOB member since 2005-08-27)

You might be able to do this with security if you have separate groups of users for each scenario. If you deny some users access to the fast processing WebI servers they wouldn’t be able to use it.

It sounds like your setup may be too complicated for this but it is another option.

And how do you deny rights to users/groups from accessing a ‘server’? My understanding of ‘User Security’ option on a server/server group is just for controlling who gets to manage a server (start/stop service, etc.) and not for accessing the server via reports.


Farhan Jaffery :us: (BOB member since 2005-08-27)

It doesn’t seem to behave that way.

We don’t allow emailing from our WebI Job Servers. I won’t get into why here.

We have some administrative reports set up that we wanted to enable the notifications on them to our Business Objects administrators. We set up an additional WebI Job Server and set the Everyone access to “No Access” and left the Administrators access as it was.

I wrote a report against the audit database looking at this particular Job Server only to report any use by any one other than an administrator. It has been in place since February and there are no records of it being used for anything but our administrative reports like we wanted.

It’s probably worth a try. Set up something like we did with a report to monitor its usage and see what happens.

Hi John…I’m trying to do exactly that, but I’m seeing the opposite of what you are seeing. I’ve denied access to a specific user group to the specific server group. I can do the ‘check user rights’ and verify that the user group is in fact denied access to the group, but when I look at the audit report, I can see users in those groups hitting the servers that they are denied access to. Does this setting require a server restart to take affect? This is our production system, so I’m trying to avoid restarting in the middle of the day.


ajunell :us: (BOB member since 2004-05-03)

It’s possible. What version of Business Objects are you on? Maybe there is something different between versions. This is functioning on XIR2 sp5 with fix pack 5.4. We have a limited user base for Web Intelligence that could play a role also. I don’t know that I have an explanation for you.

Where do you work in Amarillo? I grew up in Amarillo.

Thanks John. We are on XIR2 SP3. I’ll try to stagger some service restarts and see if that resolves the situation.

I work for CS STARS which used to be called Corporate Systems.


ajunell :us: (BOB member since 2004-05-03)