How to delete modeler data using data action or multifunction action

[rijin_baby61]

Hello,
I would like to know if there is some way to delete the modeler data using Data Action or Multi-Function action

I tried the DELETE() function in data action but this replaces the data as null and doesn't clear the data.

I wanted to perform the delete action as shown in below fig

but not manually as above but using a data action or a type of multi-function action API or anything else

Regards,

[William_Yu1]

Hi rijin_baby,

DELETE() keyword actually should perform the same as fact delete from model. I guess you see null only because other measures are not deleted. If you delete all measures, you should see record been cleared.

[N1kh1l]

rijin_baby

If a user has write access to a dimension member via DAC, then that user will be able to update the fact data for that dimension by entering a zero (0), clearing the data in the table and publishing it, or going into the model and selecting the delete facts option. From a Data Action point of view I think DELETE() is the optimum choice.

Nikhil