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 😅
How to connect the growth % which has the Product family as dimension with the P3 SKU using intermediary module..I'm stuck Can someone help?
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.…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
