01-18-2023 12:47 PM - edited 01-18-2023 12:50 PM
Hi @OSAdmin
We have a use case where the existing base entity members will be removed from the parent entity and the data of existing base entity member or the parent entity member needs to be copied into the new base entity that will be created under it, is there a way we can achieve this within cube through Business Rules or Data Mapping after metadata updates are applied and without asking users to update/adjust manually
The above can happen with multiple parent child combinations.
Before Metadata Change Hierarchy
A (Parent entity) - Data - 40
A1 (Base entity 1) - Data - 30
A2 (Base entity 2) - Data - 10
After Metadata Change Hierarchy
A (Parent entity) - Data - 40
A3 (Base entity 3) - Data - 40
Orphans
A1 (Base entity 1) - Data - 30
A2 (Base entity 2) - Data - 10
Thanks,
Vishal Pai
01-18-2023 08:21 PM
You could do it using a business rule, get a data buffer on the parent entities. then find the children of the parents from api.pov.entity.name or memberid, use a memberscriptvalue to move to a different dataunit. then consolidate.
01-19-2023 03:43 AM - edited 01-19-2023 03:45 AM
If you don't want to use rules, you could do something like this:
Remember that you cannot orphan members that contain data. Just switch the "In Use" property to False if you cannot remove data from them, without orphaning them.