dbTalk Databases Forums  

create .cub without Analysis Services/SQL Server

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


Discuss create .cub without Analysis Services/SQL Server in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard Bond
 
Posts: n/a

Default create .cub without Analysis Services/SQL Server - 05-06-2004 , 12:44 PM






Hi,

Is there any way of creating a local .cub file by inserting data from an
array i.e. having no Source DSN.
(we've already got aggregated data/schema in flat files that I'd like to put
straight into a cube)

I really would like a definitive no answer if possible.

please can someone say no

regards,

Richard




Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: create .cub without Analysis Services/SQL Server - 05-12-2004 , 02:22 AM






It is possible, although not trivial.

Check out documentation about DIRECTLYFROMCACHEDROWSET

http://msdn.microsoft.com/library/de...dldml_8ook.asp

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Richard Bond" <Richard.Bond (AT) tnsofres (DOT) com> wrote

Quote:
Hi,

Is there any way of creating a local .cub file by inserting data from an
array i.e. having no Source DSN.
(we've already got aggregated data/schema in flat files that I'd like to
put
straight into a cube)

I really would like a definitive no answer if possible.

please can someone say no

regards,

Richard






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.