How to clear the VarianceExplanation comment
Hi All, is there any way to clear the added comments in V#VarianceExplanation/V#Footnote using rule or any other method. I tried using rule but it's not working as expected. we are storing our comme...
Two potential options:
1) The Manual Route:
- Navigate to any Cube View where a comment is stored.
- Right-Click the comment/the cell containing the comment -> Data Attachments for Selected Data Unit
- Delete comments as required using the delete button 'X'
- Note: this works because you've indicated comments are stored in the same entity/scenario (thus the same Data Unit)
2) Automated / BR Route
- Write a SQL Delete Statement in an extender BR
- Make sure you have your criteria setup appropriately so that you are only deleting the comments you want to target
- !WARNING! its possible to royally screw things up using raw SQL statements. Caveat emptor.
I'd advise option 1 purely from a safety standpoint.
