Forum Discussion

LisaL's avatar
LisaL
New Contributor
6 months ago

Changing member rollup without moving historical data

Hello,  We are currently investigating the possibility of moving two UD members to a new parent in the dimension in the middle of the year without changing how historical data roll up.  Illustrat...
Metadata
Time
KarlT's avatar
KarlT
Contributor III
6 months ago

Hi LisaL, it sounds like creating an alternate rollup is your best bet if you want to be able to report against the old one and the new one. It might be more sensible to duplicate the existing hierarchy with all parents having a suffix added (_2024 or whatever makes sense), then reorganise the existing hierarchy into your new structure. This should hopefully minimise the effort of adjusting reports/rules etc (unless there are new parents that need to be added of course).