Accesing offline cubes with MS Excel 2003

Hi,

I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source".

I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures.

I have MS Excel 2003 (11.8146.6568) SP2, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft Core XML Services (MSXML) 6.0 instaled.

Thanks for help,

Martin

Hello! This is only from what I have read.

To create local cubes you can write XMLA commands in Management Studio or write code by using the SSAS2005 object model called AMO.

I do not think that these two possibilities are part of Excel 2003.

HTH

Thomas Ivarsson

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
Ashok

Hi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
AshokHi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S
|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian