Hello, I want to delete the module's data efficiently. With 100+ modules, manually removing them one by one would be too time consuming. Don't you know how to do something? Thank you
Hi @toshihiko ,
Can you please explain the requirement more in detail why do you want to delete data from 100+ Modules?
otherwise, you have to create multiple actions to clear the data from the modules, you can refer below link for your reference
Thanks
Akhtar
thank you. The link you provided was very helpful. The reason for deleting the data is to delete the data entered in the previous year after switching the fiscal year. About a third of the modules do not have a version in the dimension.
@toshihiko,
If I understand you currently you would like to delete the data in the modules after each year as it is no more relevant, please explore bulk copy functionality to copy 0 into these modules from one year into another year.
Thanks & Regards
Badam Anjani Prasad
Matasma Digital
@Badam ,
Thank you for your comment.
Do you mean a bulk copy of versions?
I'll try it.
You can do it on time to time as well.
Bulk copy requires a source item, and in your case needs to be 0. It's also only for copying one item into another item. That would mean you'd have to use Bulk Copy multiple times for each target period to clear. Bulk copy is great but it's a blunt instrument with not a lot of fine control over other dimensions.
I do have a question about why the previous year needs to be cleared. Formulas can certainly choose to treat prior year as zero and you can use DCA to effectively hide data in prior years if you don't want users to see them.
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
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…
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.…
