I have the following recordsets:

ID Name Parent Date
1 Total Total 1/1/2003
2 Total Total 2/1/2003
3 North Total 1/1/2003
4 North Total 2/1/2003
5 South Total 1/1/2003
6 South Total 2/1/2003
7 Sales1 North 1/1/2003
8 Sales1 North 2/1/2003
9 Sales2 South 1/1/2003
10 Sales2 North 2/1/2003
11 Sales3 South 1/1/2003
12 Sales3 Sales1 2/1/2003

My problem is that sales2 changed from South to North
and Sales3 is working for Sales1 in 2/1/2003. This means I have an
unbalanced hierarchy
According to AS Help, only parent-child dimensions do support unbalanced
hierarchies.
I tried to set up a parent-child dimension but i wasn't able to make that
dimension working.
Is there any other way to solve that issue?
Any help appreciated.

Thanks

Axel