Delete Annotations

Hi Bill,

I faced the similar situation, the approach i took was of claring it from database, since Data Annotations in OneStream are stored in "DataAttachment" application tables. I wrote a quick sql script to delete the annotation data for the required intersections and it was good for me. I know this is not the ideal way one should do it, since manupaliting directly within database can cause issues if not done correctly, but unfortunaltely we don;t see any other way.

This is the simple snippet

DELETE FROM DataAttachment WHERE COL_NAME = [VALUE];

Let me know if you need any additioanl assitance on this.

---

BillHandelman wrote:

Does anyone know how to delete Annotations? I have a DM step and no matter how I set it, it clears the numeric data but not the annotations. I see code to set an annotation value but do not see any code that will delete annotations.   Any thoughts?  Thank you, Bill

---