Hi all,

I'm trying to build a dynamic parent-child dimension
My table has the following fields.
Name,Parent, Timestamp

Has anyone an advice who i can do this within AS?
I always get the error message "The dimension member key is not valid"

Thanks

Axel

Hi Axel,

try extending your table into:
ID (Number)
Name (Char)
Parent_ID (Number)
Timestamp (Date)

Then fill it with rows and use AS dimension manager to
create parent child table.

One advice: If you can work without parent child tables,
don't use them!!

HTH Lutz

Hi Lutz,

I've tried that version but still getting the same error.
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

My problem is that sales2 changed from South to North.
The idea was to solve the problem with the parent-child dimension.
Is there a better way to solve that issue?
Any help appreciated.

Thanks

Axel