Parent child dimension on a slow changing dimension, hiding duplicated? -
10-29-2005
, 07:18 AM
Hi,
I have an employee dimension which is a slow changing dimension.
This dimension is also a parent-child dimension.
The problem is:
when the employee has something changing (like address, position...) a new
record is created, then in the hierarchy, I see 2 times the same name for
this employee.
So, "John Smith" has 2 children "Maria" and "Maria"...
¸If the user ask for a particular date for the measure, there is no problem,
but for aggregated data like the year... there is 2 names... and my users
will dislike this.
there is a way to display only 1 name?
I'm using AS2005.
thanks.
Jerome. |