When using PI Builder add-in for Excel to retrieve attribute or analysis configuration, we sometimes want to enable the option at Settings > Retrieve > Show Simplified Configuration Strings in order to remove the GUIDs. However, when doing so we find that the substitution parameters are also replaced with the fully resolved path which is not what we desire, especially if we need to export to another environment.
e.g. %server% will resolve to the default PI Data Archive but this may be different between systems.
It would be better if removing GUIDs or replacing substitution parameters were separate options as we sometimes need to retain the substitution parameters when publishing from PI Builder.
The current workaround is to retrieve the attribute or analysis configuration onto two different sheets with one using Simplified Configuration Strings and the other without. Any desired substitution parameters are then copied back onto the sheet with the Simplified Configuration Strings. This can be tedious however.
