We have quite a large cube with historical sales data for the past years.
Now, one of the sales representatives quits the company and his sales area is divided and distributed to his 3 successors.
To be able to do past-based planning, his complete data inside the cube shall also be evenly distributed to those 3 new sales reps.
I think, if it were just one new sales rep, the element could just have been renamed, but how can I divide the element?
Has anybody done something like that before?
Now, one of the sales representatives quits the company and his sales area is divided and distributed to his 3 successors.
To be able to do past-based planning, his complete data inside the cube shall also be evenly distributed to those 3 new sales reps.
I think, if it were just one new sales rep, the element could just have been renamed, but how can I divide the element?
Has anybody done something like that before?