2

We have a SSAS database (SQL Server 2012 Enterprise) with 4 cubes in it. 1 of the cubes is significantly bigger than the other 3. We want to process the 3 smaller cubes at regular intervals during the day and update the large cube every night.

A really basic question, if I just process a selected cube, does that still process all changes in measure groups and dimensions that are included in that cube?

To put it another way, will the data in the cube that I process be exactly the same if I process just 1 cube or if I process the whole database?

1

There is a huge difference.

If you process a cube then it processes the measure groups and partitions inside it.

If you process a database then it also processes the dimensions

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.