08-12-2022
01:10 PM
- last edited
a month ago
by
JackLacava
I may have a requirement to filter a member list based on the project manager.
Whenever data is loaded the PM assignment may change.
I am thinking of potential ways to capture the current PM assignment, but don’t know if they are possible.
Thanks
Solved! Go to Solution.
10-03-2022 05:21 PM
We are updating the Text4 fields through transformationeventhandler rule.
08-12-2022 03:36 PM
I was able to validate that U2#TotalProject.Base.Where(Text4 Contains |UserName|) works.
Now the big question; can a member text field update be automated in a simple process?
10-03-2022 05:21 PM
We are updating the Text4 fields through transformationeventhandler rule.
08-15-2022 07:55 AM
Between this question and https://community.onestreamsoftware.com/t5/Partner-Forum/Automated-member-text-field-update/td-p/938... it feels like this is all better suited through a BiBlend process. Have you explored an option doing this through a BiBlend process vs. trying to maintain all this in a Cube and through Metadata?
10-04-2022 11:39 AM
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.