SQL Server Performance Forum – Threads Archive
Altering a Dim to Slowly changingI’m looking at altering a Dimension on a normal cube ( we run AS for SQL 2000 ) from normal to "changing" A couple of questions I have please :
(1) I assume I can change it via just changing the "Changing" property in Advanced for the Dimension properties from false to true. Is this right
(2) Is there anything else apart from reprocessing the cube I need to do after changing the property?
(3) what will be the impact on the cube performance now?
We are finding as we are in a large environment that dimension changes can come through without warning, and ratrher than re-process the whole cube database, would rather just let the dimension slowly change. Any help appreciated. Steve.