dbTalk Databases Forums  

Need a DSO expert!!!

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


Discuss Need a DSO expert!!! in the microsoft.public.sqlserver.olap forum.



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

Default Need a DSO expert!!! - 09-06-2005 , 07:10 PM






All,

I'm creating new cube partitions based off of the latest exisitng cube
partition. The ubiqutous code floating around the web (Clone,
CloneMinorchildren) copies the structure, and changes the source data, and
other ancillairy properties, BUT IT DOES NOT CLONE THE AGGREGATIONS!!!

Stuck,

Jim



Reply With Quote
  #2  
Old   
SQL McOLAP
 
Posts: n/a

Default RE: Need a DSO expert!!! - 09-12-2005 , 10:58 AM






Jim -

CloneMajorChildren will include the aggregations.

Good luck.

- Phil


"Jim_OLAP" wrote:

Quote:
All,

I'm creating new cube partitions based off of the latest exisitng cube
partition. The ubiqutous code floating around the web (Clone,
CloneMinorchildren) copies the structure, and changes the source data, and
other ancillairy properties, BUT IT DOES NOT CLONE THE AGGREGATIONS!!!

Stuck,

Jim



Reply With Quote
  #3  
Old   
Darren Gosbell
 
Posts: n/a

Default RE: Need a DSO expert!!! - 09-12-2005 , 07:37 PM



Someone else asked a similar question last week and I posted a vbs
script on my blog that will take a given partition and copy the
aggregations to all the other partitions in that cube.

See the full script here:
http://www.geekswithblogs.net/darren...les/53082.aspx

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <DBBA18D4-961B-48FD-A473-0C8571304DC8 (AT) microsoft (DOT) com>,
SQLMcOLAP (AT) discussions (DOT) microsoft.com says...
Quote:
Jim -

CloneMajorChildren will include the aggregations.

Good luck.

- Phil


"Jim_OLAP" wrote:

All,

I'm creating new cube partitions based off of the latest exisitng cube
partition. The ubiqutous code floating around the web (Clone,
CloneMinorchildren) copies the structure, and changes the source data, and
other ancillairy properties, BUT IT DOES NOT CLONE THE AGGREGATIONS!!!

Stuck,

Jim





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.