dbTalk Databases Forums  

Many local cubes in one ".cub" file.

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


Discuss Many local cubes in one ".cub" file. in the microsoft.public.sqlserver.olap forum.



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

Default Many local cubes in one ".cub" file. - 02-09-2004 , 05:06 AM






Hi all

is it possible to save more than one local cube in a single ".cub" file
In other words, is it possible to create one .cub file containing more than one local cube
How can I get this

Thanks
Best Regards
Luc


Reply With Quote
  #2  
Old   
Zoltan Hangyal
 
Posts: n/a

Default Re: Many local cubes in one ".cub" file. - 02-09-2004 , 05:12 AM






Hi Luca,

From BOL:

If the specified cube file already exists on the local computer,
PivotTable Service overwrites this existing file with the new local cube
unless you set the UseExistingFile property of the Microsoft® ActiveX®
Data Objects (ADO) Connection object to a value that begins with Y (for
YES), T (for TRUE), or a nonzero numerical value.


If the name of a cube is different from the name of a cube already in a
cube file, this new cube is appended to the old one.

Best Regards

Zoltan

Luca Ã*rta:
Quote:
Hi all,

is it possible to save more than one local cube in a single ".cub" file?
In other words, is it possible to create one .cub file containing more than one local cube?
How can I get this?

Thanks.
Best Regards,
Luca



Reply With Quote
  #3  
Old   
Luca
 
Posts: n/a

Default Re: Many local cubes in one ".cub" file. - 02-09-2004 , 05:56 AM



Hi Zoltan

thank you for your prompt replay
Setting the UseExistingFile property as you suggested, I have just created one file containing more than one cube

Thanks

Best Regards
Luca

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.