We are updating the Text4 fields through transformationeventhandler rule.
Since this thread is set as an accepted solution, I would like to add a note for future OneCommunity viewers. If a requirement requires any metadata members or metadata properties to change every time data is loaded, I would suggest investigating solutions such as Thing Planning or BI Blend processes to handle the ever changing metadata or metadata properties vs. maintaining this through a Cube structure, which is intended to be more static than fluid. The TransformationEventHandler is using BRApi's to cross from Stage Engine to Finance Engine. There is considerations on performance in a production environment, auditability, maintenance, and troubleshooting. Some things to think about when weighing design options.
