Hi,

I have SSIS package that add's data to the existing dimension using (Add/Increment), and at present we had an issue with the data and we have entered wrong values in the dimension. Is there a way to delete the data from dimension based on Date field.

Like in SQL: DELETE FROM dbo.Table Where DateField = GETDATE(), do we have anything for MDX?

• Edited by SQL_Gun 15 hours 44 minutes ago edit

Hi,

The only way to change the data in a dimension is to process the dimension.

Do you have any related/unwanted data in facts/partitions? If so you need to process the partitions as well in order to reflect the latest data.

Hope this helps!