i like to use my Excel pivot from other domain, but I always get the error message "Cannot find repository". I tried a ping on IP of analysis server, no problem. The connection string includes the IP adress as well. Anybody knows the clue ?
I have to re-post my question, hopefully anybody got same problem.
Here my problem again:
A client from other (trusted) domain can ping to my analysis server, but cannot use the excel pivot table using the cube of same analysis server. It is saying "Cannot find repository".
Pivottable is working fine from same domain as analysis server.