dbTalk Databases Forums  

Requirements for writing back measures to a cube from Excel 2002

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


Discuss Requirements for writing back measures to a cube from Excel 2002 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim Reisz
 
Posts: n/a

Default Requirements for writing back measures to a cube from Excel 2002 - 06-10-2004 , 11:37 AM






What are the requirements to write a measure via Excel 2002 to a cube?

I have done the following:

1. Enabled writeback on the cube.
2. Used example code from "Extending OLAP" on MSDN in the workbook.
3. The cube was created using SSABI.

Here are the references enabled in the spreadsheet:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.8

Excel never returns from executing the update cube statement to a local or
remote cube.

Any suggestions will be greatly appreciated.

Thanks.

--Jim



Reply With Quote
  #2  
Old   
Ovidiu
 
Posts: n/a

Default Re: Requirements for writing back measures to a cube from Excel 2002 - 06-11-2004 , 12:56 AM






Please help me to obtain SSABI.
I can't download it from microsoft, because I obtain a message :

"
Registration

The Wizard you are trying to access is no longer available
Please be sure to remove any bookmarks you have to this location on
microsoft.com to avoid the error in the future.

"
Thanks

Ovidiu

"Jim Reisz" <jreisz (AT) msn (DOT) com> wrote

Quote:
What are the requirements to write a measure via Excel 2002 to a cube?

I have done the following:

1. Enabled writeback on the cube.
2. Used example code from "Extending OLAP" on MSDN in the workbook.
3. The cube was created using SSABI.

Here are the references enabled in the spreadsheet:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.8

Excel never returns from executing the update cube statement to a local or
remote cube.

Any suggestions will be greatly appreciated.

Thanks.

--Jim





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

Default Re: Requirements for writing back measures to a cube from Excel 2002 - 06-11-2004 , 03:37 AM



Hi Ovidue,

What link did you use, I just had a look at:

http://www.microsoft.com/sql/ssabi/howtobuy/default.asp

And that worked fine.
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.