Can any one suggest what is easy way (or all available options ) to clear the data present in exising module.
Hi You can get into blue print mode and copy the existing formulas of line items to excel, then change all the formulas cells value to "0" and then copy back all the fomulas to line items, this is the easiest way I have found
Update:
https://community.anaplan.com/t5/Anaplan-Support-Knowledge-Base/How-can-I-mass-delete-data-from-a-Module/ta-p/5381
Leo response to this is better way, have the line item with format "No Data" and then import it back to clear
The most efficient way I have found is as follows :-Create a copy of the "To be cleared" module and call it "Clearing" module.In the "Clearing" module keep only the first Line Item (LineItem1).Set the Format for LineItem1 to "No Data".Then from the "To be cleared" module Create a data import using "Clearing" module as the Anaplan source.Within the Mapping tab select "Clear Target Prior to import"Within each of the other dimension/hierarchy tabs on the import select the option to clear All Items
Run the import.The result is the "Clearing module" takes up zero cells of space and the "To be cleared" module is flushed out for all data.
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…