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 😅
Why are non‑admin users unable to view Module information on the Anaplan page, while workspace administrators can? (After click the three dots on the grids right up corner) Are there any configuration options that allow non‑admin users to view module details without granting full workspace administrator access?
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
