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 16 hours 27 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!

Hi ,

MDX is the query language for cubes so you can not write deletion Query using MDX.
I'll suggest you to modify your SSIS package that populate values in your dimesnion tables
then process you dimesnion in cube.

Thanks

There's also a dimension processing task available in SSIS 2012 which does incremental processing of dimensions

see

http://www.mssqltips.com/sqlservertip/3013/introduction-to-the-dimension-processing-destination-in-ssis-2012/

Ideally you wont do physical delete from dimension tables. You will be mostly implementing a soft delete logic using an update operation on a flag field.