Incremental updates of dimensions (meta data) and cubes (data) operate under somewhate different rules. Incrementally updating a non-changing dimension will add new members as well as update member property...

You might consider changing the member name property in the dim definition to reflect the year and quarter. This would resolve your need here as well as make the...

If you set the member key to time_id but do not change the member name column (also to time_id) you will create a situation where multiple members of the same...

The primary difference is Partitioning. With standard edition you may create only 1 partition per cube (actually, the partition is created automatically). With enterprise edition you may create...

If you have not yet found the a consultant for this project I would be happy to speak with you about it.

Scot J Reagin

sreagin@aspirity.com

http://www.aspirity.com

Scot J Reagin

Hi Joe -

The size is Analysis Services estimated cube size. Although the results in your case are extreme, it's not all that unusual for the estimate to be substantially...