dbTalk Databases Forums  

EXCEL Local Cube

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


Discuss EXCEL Local Cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ale Dori
 
Posts: n/a

Default EXCEL Local Cube - 09-07-2004 , 09:03 AM






I'M trying to create a local cube from a Pivot Table in an Excel Scheet whit
the:
"Not On Line OLAP" function (this is the translation from italian).

I get this error:
OleDB Provider for Analysis Services:
Data Source Provider Error

Any Ideas?

Thanks




Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: EXCEL Local Cube - 09-08-2004 , 03:06 AM






Hi,

Did you install \msolap\install\PTS\PTSfull.exe of Analysis Server sp3 on
this excel machine? That will upgrade the provider to the 760 version (sp3)
a lot of Excel version (depends on version) are running old providers.

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."


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.