Wednesday, March 7, 2012

AS connection problems from Excel

I have problems to create connections to some of my cubes from Excel.

Configuration

Client- XP professional with Excel (2007, B2TR) and SQL 2005 SP2 TR client part's installed.

Server - Windows 2003 R2 with SQL AS 2005 SP2 TR.

Logged in as administrator with same password on client as server.

There are no rules configured for any of my databases.

When I try to create a new Analysis connection from Excel there is no cubes in the list of available cubes for some of my databases.

It works great for two om my databes but not for the others. I have compared my databases but I can't find anything that is different. And it works great to browse all my cubes from SQl Server BI Development Studio from my client.

Any idea?

Thanks,
Christer

If the cubes are deployed and processed, then you suppose to see it in the Excel 2007 beta 2. Can you be more specific in your question, I might can help as I am using the same configuration you have.

IMRAN

No comments:

Post a Comment