How to clear data from a module

Can any one suggest what is easy way (or all available options ) to clear the data present in exising module.

Tagged:

Best Answers

  • ben_speight
    Answer ✓
    1. To reset all the data to the default value for each line item's type, you can perform an import from the module to itself with a cleared out manual map on at least one dimension, and the "clear target prior to import" flag checked.
    2. If there are not many line items you can manually set a required value as a formula for each line item in the blueprint. When you remove the formula, the value will be retained as data.
  • Hi, 

    If you want to do that clearing frequently, the easiest way is to create a similar module with exact line items and dimensions and write "blank" formula for all line items and then do the import from new module to existing module. Whenever you want this clearing to happen in the future you can just run the import action item. 

    Thanks 

Answers

  • 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