Using XIr2 --> OLAPi over Tomcat. MS Analysis services are on a separate Windows 2003 box. We can’t seem to get the OLAP connection to work no matter what. Do we NEED a domain account to start the services so OLAP can access accross? Has anyone have this configuration working?
Ang.
angelsd1 
(BOB member since 2005-10-21)
There is a BO Knowlegdebase article “c2019144”
It basically says that the user account under which the Apache Tomcat service is running needs sufficient rights to the remote OLAP Server.
In your case Tomcat needs to run under a Domain user and not under localsystem account.
Hope this helps.
botom 
(BOB member since 2006-06-19)
…we had this problem when we tried to access an MS OLAP 2000 server which was not part of active directory forest and the external trust did not work to the NT domain. As soon as both servers were in the same domain, it worked nice.
However, compared to other OLAP frontends, the BO WebOLAP is so poor and confusing, I would not dare a worldwide rollout for my users.
Probably designing an OLAP universe in designer would offer in some cases better usability, but I guess with poor performance (haven´t tried this out yet)
cheers, tom
botom (BOB member since 2006-06-19)
Have not fully migrated to XI R2. However, we use OLAP with 6.5 and it sometimes expects our network ID and password on one BI server and not on the other. Have not figured quite as to why this difference. On a similar note, how is the security set on your OLAP database? Is it the default settings or did you change anything in there?
JSanthanam 
(BOB member since 2003-12-17)
We tested to access Cubes on Microsoft Analysis Server 2000 from BOXIR2SP1 and it worked fine. We have restricted access to the cubes on the Analysis Server to certain domain users. So everytime you want to access cubes from BO via Web OLAP, it prompts you for username and password. However, if username and password is wrong, we get a strange error message (some kind of file seems to be missing)… no idea whether this is just a problem of our installation or a general issue…
It is possible to set up Single Sign On (SSO) with OLAP… Business Objects has got a technical whitepaper on that - it involves changing the user running the OLAP worker process to a domain user, and so on.
Cheers, tom
botom (BOB member since 2006-06-19)
How robust is the OLAP reporting in XI? It was not all that great in 6.5 and we started to use the Business Query MD add on for Excel which was /is a great tool. In 6.5, dimension members were put into random folders created by BO and you pretty much had to figure out which folder contained your dimension member of interest. This was a tedious process especially when your OLAP model had tonnes of dimension members like we do. Has this been resolved? Appreciate any feedback.
JSanthanam (BOB member since 2003-12-17)
We were able to get the New Olap Intelligence functionality working in R2. There were two issues with our environment.
Issue 1: Add the registry values covered in OLAP Intelligence installation documentation to enable OLAP Intelligence to use Kerberos authentication we chose the Negotiate option which will try Kerberos and then default back to NTLM authentication.
Issue 2: Analysis Services needs to start as the system on the remote server, we do not have a domain administrator account to test so have simply reomoved the domain user account that previously started the service.
This solution will allow you to create OLAP Intelligence documents through Infoview in R2.
jefbuckeye (BOB member since 2006-01-07)