Business Analytics in multi server environment

Frekie

Dear -

has any one installed Business Analytics in a multi server environment ?

I do mean an environment where you have
Navision on machine 1 (SQL 2005)
and
Business Analytics on machine 2 (SQL 2000 + OLAP)
and
where clients are accessing Navision form Terminal Services.

Do I have to install BA Basic and BA Advanced clients on the Terminal Server ?

How to tell where the Business Analylitics server is situated ?

Probably I am missing something here but ... it keeps me from sleeping ;-)

Many Thanks for any response.

Frekie

kine

I am running MS SQL DB for Navision on onse server and BA on another... It is little tricky because the Navision BA Basic doesn't count with this possibility, but it is working after little change... zou just need to add one parameter when calling BAConfigurator for creating the cube.

1) You need to have Navision on the server with BA
2) You need to create the cubes from this Navision (on BA server)
3) You need to change code in table 700 in function StartConfigurator

IF RECORDLEVELLOCKING THEN BEGIN
  IF NOT GetFieldRefByName(FieldRef,RecRef,'Host Name') THEN
    ERROR(Text004,RecRef.CAPTION);
//removed  Params := Params + ' -s"' + FORMAT(FieldRef.VALUE) + '"';
    Params := Params + ' -s"' + "Navision Server Name" + '"'; //added
END ELSE
  IF GetFieldRefByName(FieldRef,RecRef,'Host Name') THEN
    Params := Params + ' -s"' + FORMAT(FieldRef.VALUE) + '"'
  ELSE
    Params := Params + ' -s"' + "Navision Server Name" + '"';

This change of code will prevent configurator to search for the DB server with Navision DB on local machine and will use field "Navision server name" as name of the server where the DB is located...