dbTalk Databases Forums  

Parent child dimension on a slow changing dimension, hiding duplicated?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Parent child dimension on a slow changing dimension, hiding duplicated? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.