Clear an entire module

Clear an entire module

Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off.

 

Current workaround: Create a duplicate module that is filled with 0's then do a module-to-module import before doing the import. This seems like a waste of space and unnecessary processing.

 

Idea: Have an option in the Import Action to clear the entire module for an import. In the module, also have an option to clear that module

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
2 Comments
Community Manager
 
Status changed to: Needs Community Support
Certified Master Anaplanner

Aline's idea would be helpful!  Our team has numerous actions that to clear cells.  To do this, one needs a module with the exact dimensionality of the target line item, so lots of wasted space and actions!  Currently, we are using roughly 20 million cells and five actions to do this in one of our models.

 

I have tried a few experiments with importing a spreadsheet into the Blueprint view of the target module in hopes to set the formula to "0", "BLANK", or "FALSE" (whatever the line item's format is to clear) without much success.  The next action would then remove the formula.  Has anyone imported into a Blueprint view with any success?