Greetings,
We have recently set up a Windows 2003 server with the BW Precalculation service. We have successfully configured the precalculation service to attach to our BW Production server and it is functioning properly. We have workbooks that are precalculated and emailed each day.
As we develop new precalculation scenarios we would like to develop and test these in our BW Development system. However, I cannot get the existing Precalculation service to connect to both our BW Development server and our BW Production server. It will either attach to our BW Production server or our BW Development server but not both.
I've tried various combinations including...
deleting all BW calculation services from SPRO in both BW systems.
logging onto the server where the BW precalc service is running.
stopping the BW precalculation service
from the server, creating the SPRO configuration in both bw servers.
restarting the precalc service.
the precalc service will then attach to one of the bw servers but not both.
Does anyone know if it's possible to have a single precalculation service handle requests from multiple BW systems? If so, could you please help me with the configuration steps?
Thanks in advance,
David Eady
Reporting Team Lead
SI Corporation