Accessing Cube data through Excel -
09-07-2006
, 05:34 PM
Hi,
I am trying to access the data in a cube built in SSAS 2005 using
Pivot tables through Excel.I dont have Microsoft OLE DB Provider for
Analysis Services 9.0 in my Excel. I have Windows XP Proffesional as my
OS and Office XP.
1. Can I still access the cube data without having the 9.0 provider
through excel.
2. If I need to have a 9.0 provider is there a document by microsoft
which states that(My administrator wants it).
3. If I have to have Microsoft OLE DB Provider for Analysis Services
9.0 in my excel what are the compnents that I need to install and the
steps that I need to take to make it possible,
Thanks |