dbTalk Databases Forums  

Excel cub

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


Discuss Excel cub in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mariusz Sobstel
 
Posts: n/a

Default Excel cub - 04-13-2004 , 01:40 AM






Hi,
Is it possible to make an offline Excel cube file (with pivot table) without
making .cub file. I mean to store it in the same Excel file where is pivot
table.

B.rgds
Sobota

P.S. I make the pivot table using online conection to Analysis Server.



Reply With Quote
  #2  
Old   
Andrey Taranov
 
Posts: n/a

Default Re: Excel cub - 04-16-2004 , 02:45 PM






Yes, if you can write on VBA, first you must update one of sheet in excel
file with your data - second you can create cube based on this sheet

"Mariusz Sobstel" <m.sobstel (AT) wp (DOT) pl> сообщил/сообщила в новостях следующее:
news:uKOXHHSIEHA.2480 (AT) tk2msftngp13 (DOT) phx.gbl...
Quote:
Hi,
Is it possible to make an offline Excel cube file (with pivot table)
without
making .cub file. I mean to store it in the same Excel file where is pivot
table.

B.rgds
Sobota

P.S. I make the pivot table using online conection to Analysis Server.





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.