I have a dimension modeling issue with Strategy Management. I want to know if there is a way to utilize the dimension versions in SSM to keep historical data accurate when a dimension member shifts in the hierarchy. Let me explain:
Dim previous state:
Parent1 -> Child1, Child2
Parent2 -> Child3
Dim current state:
Parent1 -> Child1
Parent2 -> Child2, Child3
The business has reorganized its business which caused the dimension member Child2 to shift under a new parent. I want all KPIs going forward to use this new structure, however, when I look back at historical measurements, I want the data to reflect what was accurate then, which was the previous state in this example.
Is this possible in SSM?
Thanks for the help.