dbTalk Databases Forums  

Accessing Cube data through Excel

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Accessing Cube data through Excel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tsachin@gmail.com
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.