Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious
//GP
Hi @GP , 1 of the ways is to copy the entire line items tab to an excel, find & replace your line item and then paste it back. It might need some work in the excel to add the ' before and after the formula but would also save you considerable amount of time. If your line item is generic & present in multiple modules with the same name then you could just rename it for this task to something very unique (both source & target line items) and then after the exercise rename it back to what it was. Hope this helps! :)
yes multiple modules, hundreds..and no, the line item is referred in other formulas in other module line items, its not just doubled by name and content. At least i could use the internal replace function (Ctrl+H) in the formula editor in anaplan, this helped its not just renaming. i want to use another (a new one) Line Item which replaces the old one, and the old should remain im already done - did it manually, but im sure i need to do this again somewhen
@GP - Yes, you could copy this tab to an excel and lets say in this example I want to change the line item "Mapping" to "Mapping new" in the entire model wherever it exists. Copy paste this tab into an excel, do a find & replace for mapping to mapping new & copy back the result.
This way all the formulas referring to mapping earlier now refer to mapping new.
i didn't dare to paste the full line item collumn 😅
We have an Anaplan model that uses "Fake Time" - that is a time dimension specifically constructed for the application and not one found native to Anaplan. For this reason the Opening / Closing Balance summaries don't work. We would like to be able to show the opening and closing balance at the beginning end of each weekly…
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
