Partition Wizard and Estimated Size -
01-04-2006
, 09:23 PM
Say I have the following:
A Dimension called States which has 50 members. It has two levels,
EastWest and State. For simplicity (not accuracy), 20 states are in
the East member and 30 states are in the West member
States
East
State 1
...
State 20
West
State 21
...
State 50
A Cube that has 2 partitions. On partition for East and one for West.
In the DSO model there are two places to set EstimatedSize for a given
level of a Dimension: clsDatabaseLevel and clsPartitionLevel.
Note: You can only set the DatabaseLevel in Analysis Manager, not the
Partition Dimension Level (as far as I know).
I am programatically counting each Dimension AND applying the slice for
a particular partition by Dimension.
So the Database Dimension Level would have a count of 50, but the
Partition Dimension Level for Partition East would have 20 and the
Partition Dimension Level for Partition West would have 30.
Every comment on the web and in the books says to set the Database
Level prior to running the partition wizard for EACH partition.
My question is: Is this necessary if you programatically set the
Partition Dimension Level.
I am guessing that the reason this process is recommended is that the
Partition Dimension Level cannot be set via the Analysis Manager, but
setting the Database Dimension Level (in Analysis Manager) also sets
the Partition Dimension Level.(?)
Since I am doing this programatically, I can certainly set the Database
Dimension Level prior to running (internally) the partition wizard, but
if that is the case, I don't understand the purpose of the PARTITION
Dimension Level having an EstimatedSize.
Thanks in advance |