Dimension processing taking too long

A regular dimension with some hierarchies is defined.

StorageMode:Molap

ProcessingGroup:ByAttribute

ProcessingMode:Regular

then on processing this dimension individually, why is a "select distinct" from the relational table done for each attribute of the dimension separately and finally a select distinct <all attribs> is done in one query.

What is the purpose of this ? this slows down processing for a large dimension table.

This is not done for rolap dimensions though.

Is there a way to speed up processing for Molap dimensions.

Also what is the significance of the ProcessingGroup property for a dimension?

Regards

mat

Processing by table seems to process all dimensions from that table at the AS server while by attribute gets each unique set of attributes from the database and then indexes them etc. According to a post I've just read there may be an issue with processing by table.|||

Try modifying EnableTableGrouping server property.

See description in http://msdn2.microsoft.com/en-us/library/ms174469.aspx

EnableTableGrouping

A Boolean property that specifies whether table grouping is enabled. If True, when processing dimensions, entire dimension tables are queried at once, as opposed to separate queries for each attribute.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.