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.
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…