MS SQL Server OLAP - Unable to open a local cube in Excel

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Unable to open a local cube in Excel

Gautham

2005-11-23, 7:24 am

Hi,

I have created a local cube (Offline cube) from SQL Server Analysis Services
2005(Using GLOBAL CUBE statement) with a name LocalCube1.cub. When I am
trying to open the local cube using MS Excel 2003, it is giving a message
"This DataSource has no visible Tables".

I am trying to open the Local Cube file (.cub file) as follows :

1. In MS Excel -> Data -> Import External Data -> Import Data.

Can any one help me in solving this problem.

Any suggestions on why this message is occuring?

Regards,
Gautham.

--
Gautham

Sponsored Links