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.

Accepted answers

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.

PrevContributor

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

All comments

ben_speight

PrevContributor

harish_bk

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

PaulWestonVA

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.

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…