Hi Everyone,
Is it possible to use the "Delete from List using Selection" to empty a module?
Best regard
Patrick
Hi,
If you delete a list that is used in a module that contains data, then yes, you would delete the data in the module when you delete the list. However, deleting the list may not be the best approach because we'd have to recreate the list.
Here is a better way, borrowed from an older post: https://community.anaplan.com/t5/Anaplan-Support-Knowledge-Base/How-can-I-mass-delete-data-from-a-Module/tac-p/6738#M15 @leo_tadjudin_1
Create a line item with the same dimensions as the target you want to set to zero. Set the Format to No Data so that it doesn't take up model space. Then load that (no data) line item into your (numeric) line item that you want to clear. I tested this several times and it seems to work fine.
Cheers!
Paul
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
