When trying to connect from Analysis Office to a BW system via OLAP connection defined in CMC with server type "Group", the error below occurs:
ERROR service "?" unknown
SAP Analysis for Microsoft Office
Reproducing the Issue
- Create an OLAP connection in CMC to a BW system with server type set to "Group" to use message server;
- Try to connect to the OLAP connection via Analysis for Office;
- Confirm the error "service '?' unknown".
It is necessary to make sure that the client PCs can communicate with the BW system.
Make sure that the service name configured in the OLAP connection is also configured in the services file at <systemdrive>:\WINDOWS\system32\drivers\etc\services in the client PC.
Note: If SAP Business Objects or BW either of them is on Linux system make sure that host file entries and service name is configured in /etc/services file.
Chapter "Creating and managing BW system connections in SAP BusinessObjects Business Intelligence" in the Administrator Guide.
group, service, unknown, ?, error, connection, NiSrvLGetServNo, service name cached as unknown , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem