dbTalk Databases Forums  

Partition Wizard and Estimated Size

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


Discuss Partition Wizard and Estimated Size in the microsoft.public.sqlserver.olap forum.



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

Default 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


Reply With Quote
  #2  
Old   
Tom McCrossin
 
Posts: n/a

Default Re: Partition Wizard and Estimated Size - 01-04-2006 , 10:11 PM






I think I may have answered my own question, but please correct me if I
am wrong. I have tried to set the EstimatedSize on the
clsPartitionLevel and get an exception. It seems to be what I have
come to think of as a "ghost" field (which there seems to be plenty in
the DSO object), meaning it isn't really there. Possibly a disconnect
between the IntelliSense and the actual properties of the object (just
a guess).


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.