S
smm
Colleagues:
I'm using SQL Server 2005 w. SP2 and Excel 2007. Have tried to create a
..cub file on my local file system based on a cube I have already created in
Analysis Services. I can read the contents of an Analysis Services cube into
an XL Pivot table with no problems - I select "Offline Olap" from the "Olap
Tools" option in the ribbon - I walk through the 4 steps to create the cube
and kick the process off - after a few seconds I get a message box with an
error:
Microsoft OLE DB Provider for Analysis Services 2005 ; The following errror
occured: Unspecified error.
I try to create a cube in Analysis services with an MDX query, that doesn't
work either. Installed the various files in the Nov. 2005 feature pack
(including the OLE DB provider for Analysis Services, etc.)
Any perspectives, suggestions welcome!
Best wishes,
Michael Martin
(e-mail address removed)
I'm using SQL Server 2005 w. SP2 and Excel 2007. Have tried to create a
..cub file on my local file system based on a cube I have already created in
Analysis Services. I can read the contents of an Analysis Services cube into
an XL Pivot table with no problems - I select "Offline Olap" from the "Olap
Tools" option in the ribbon - I walk through the 4 steps to create the cube
and kick the process off - after a few seconds I get a message box with an
error:
Microsoft OLE DB Provider for Analysis Services 2005 ; The following errror
occured: Unspecified error.
I try to create a cube in Analysis services with an MDX query, that doesn't
work either. Installed the various files in the Nov. 2005 feature pack
(including the OLE DB provider for Analysis Services, etc.)
Any perspectives, suggestions welcome!
Best wishes,
Michael Martin
(e-mail address removed)