Can any one suggest what is easy way (or all available options ) to clear the data present in exising module.
Solved! Go to Solution.
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:
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.