Question for Dave W. and the community

Dave,

I still cannot get the aggregations to copy over to the new partition using --

*Clone, CloneMinorChildren*

Is there any way in DSO to explicitly copy the aggregations over to the new
partition?

And on a side note, partitioning is probably the most important performance
feature of AS, and in my opinion, the least understood and documented.

I have had top notch consulting companies build partitioned cubes for me
using just the *Clone* command (not using CloneMinorChildren), and
essentially (and unknowingly) creating huge cubes with no aggregations!!

Frustrated,

Jim

Here is the code that the Parallel Process Utility uses for incremental
processing of a partition (where it clones a copy of the partition,
processes the temporary partition, and then merges back)
http://www.microsoft.com/downloads/d...DisplayLang=en


Private Sub IncrementalUpdate(ByRef dsoPartition As dso.MDStore, ByRef
dsoCube As dso.MDStore)
Dim dsoClonePartition As dso.MDStore
Dim sClonePartitionName

' Create a temporary partition to store the new data.
' Use the tilde character to indicate to the server
' that the partition is not permanent.
sClonePartitionName = "~Incremental " & dsoPartition.Name
Set dsoClonePartition = dsoCube.MDStores.AddNew(sClonePartitionName)

' Clone the main partition to the temporary one.
dsoPartition.Clone dsoClonePartition, cloneMinorChildren

' We will use the existing partition attributes for:
'
' SourceTable
' FromClause
' JoinClause
' All of the measure names; MemberKeyColumn; MemberNameColumn
'
' These may have encodings for a particular update event. Since we don't
' know what they should be, we'll just use the values for the original
' partition.

' Process the temporary partition.
dsoClonePartition.Process processFull

' Merge the two partitions.
dsoPartition.Merge sClonePartitionName

End Sub







--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote

Dave,

I still cannot get the aggregations to copy over to the new partition
using --

*Clone, CloneMinorChildren*

Is there any way in DSO to explicitly copy the aggregations over to the
new
partition?

And on a side note, partitioning is probably the most important
performance
feature of AS, and in my opinion, the least understood and documented.

I have had top notch consulting companies build partitioned cubes for me
using just the *Clone* command (not using CloneMinorChildren), and
essentially (and unknowingly) creating huge cubes with no aggregations!!

Frustrated,

Jim

Dave,

Thanks, but I need the code to clone the aggregations as well !!!

I'm creating new cube partitions (structure and aggregations) based off of
exisitng cube partitions. The code (Clone, CloneMinorchildren) copies the
structure, and changes the source data, and other ancillairy properties, BUT
it does not clone the aggregations!!!

Stuck,

Jim



"Dave Wickert [MSFT]" wrote:

Here is the code that the Parallel Process Utility uses for incremental
processing of a partition (where it clones a copy of the partition,
processes the temporary partition, and then merges back)
http://www.microsoft.com/downloads/d...DisplayLang=en


Private Sub IncrementalUpdate(ByRef dsoPartition As dso.MDStore, ByRef
dsoCube As dso.MDStore)
Dim dsoClonePartition As dso.MDStore
Dim sClonePartitionName

' Create a temporary partition to store the new data.
' Use the tilde character to indicate to the server
' that the partition is not permanent.
sClonePartitionName = "~Incremental " & dsoPartition.Name
Set dsoClonePartition = dsoCube.MDStores.AddNew(sClonePartitionName)

' Clone the main partition to the temporary one.
dsoPartition.Clone dsoClonePartition, cloneMinorChildren

' We will use the existing partition attributes for:
'
' SourceTable
' FromClause
' JoinClause
' All of the measure names; MemberKeyColumn; MemberNameColumn
'
' These may have encodings for a particular update event. Since we don't
' know what they should be, we'll just use the values for the original
' partition.

' Process the temporary partition.
dsoClonePartition.Process processFull

' Merge the two partitions.
dsoPartition.Merge sClonePartitionName

End Sub







--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote in message
news:8D5C044F-A386-49D5-89C0-5DAC245E878B (AT) microsoft (DOT) com...
Dave,

I still cannot get the aggregations to copy over to the new partition
using --

*Clone, CloneMinorChildren*

Is there any way in DSO to explicitly copy the aggregations over to the
new
partition?

And on a side note, partitioning is probably the most important
performance
feature of AS, and in my opinion, the least understood and documented.

I have had top notch consulting companies build partitioned cubes for me
using just the *Clone* command (not using CloneMinorChildren), and
essentially (and unknowingly) creating huge cubes with no aggregations!!

Frustrated,

Jim