Derivation of Values Based on Derived Values

Content

Has anyone found a solution for deriving values on a property based on a node template? Essentially, we have an Employee dimension with multiple properties. We have a CostCenter dimension with an "Owner" property that uses the Employee dimension. We want to be able to derive an "email" property listed within the employee dimension based on the property chosen for "Owner" in the CostCenter dimension. Unfortunately, properties that are derived or set as a Node template have been restricted from the expression builder.

Has anyone figured out a work around? We can't switch the node template after registration. My understanding is that one work around for deriving properties from properties that are derived requires you to temporarily remove derivation from the source property.