Question Re: How to delete modeler data using data action or multifunction action in Technology Q&A

How to delete modeler data using data action or multifunction action

rijin_baby61 — Thu, 23 Feb 2023 18:05:31 GMT

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,

Re: How to delete modeler data using data action or multifunction action

N1kh1l — Thu, 23 Feb 2023 20:39:24 GMT

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

Re: How to delete modeler data using data action or multifunction action

William_Yu1 — Fri, 24 Feb 2023 02:22:31 GMT

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.