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

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?