What cube deployment changes will force a reprocess?

Question

Sometimes when I deploy a cube that has been changed (from BIDS), I can continue to browse the existing cube data. Other times, the engine insists I reprocess the data before I can browse the cube.

I can't find a definitive resource showing which changes require a data reprocess and which do not.

SSAS 2008.

Answer 1

In general, you need to process when

• adding or editing measures
• adding a dimension attribute
• editing dimension attribute relationships or order by properties

A more complete list can be found here.