Hi,
Anyone know how handle a SCD dimension type 2?
I have implemented the dimension over an old Analisys Services Father-Child
dimension. Now, when I process the cube I obtaing an error (name duplicate).
I handle the dimension table inserting a new record (with a different sk
key) but with the same name, in the fact table I link new facts with the new
surrogate dimension key.
Analisys services can automatically handle this kind of dimension?
Anyone have a sample or a tutorial for me?
Thank you and exuse my english.
D

I forgotten, I must do this with analisys services 2000.
Thank you.

"darkeagle" <darkeagle@nospam> ha scritto nel messaggio
news:4327ff44_2 (AT) x-privat (DOT) org...

SCD dimension are not handled by AS himself, you have to manage this
dimension in your RDBMS.

To avoid the error in AS authorize duplicated names in the dimension.

Due to the possible replication of the member you could have 2 times the
same member:

Key Name parent name start date end date
1 Paul John 01/01/2000 01/01/2001
2 Paul Mary 01/01/2001 01/01/2002
3 Paul John 01/01/2002 01/01/2003
.....

So "paul" will appeared 2 times under "John" in the dimension and 1 time
under "Mary"

If your dimension don't use any properties, then you could use the "Name"
column as the member key and you have to authorized duplicated keys. in this
case :
"Paul" will appeared only 1 time under "John" instead-of 2 times.
(solution not tested, just a theorical suggestion)


"darkeagle" <darkeagle@nospam> wrote

Thank you,
There is a problem:
How I can refer from MDX the first "Paul" or the Second "Paul" under "John"?
My tests show that in an example expression: Customer.John.Paul I refer the
last Paul inserted into RDBMS...
How I can refer the first?
Which impact of enabling duplicate keys in parent members (like aggregation,
member calculation etc)?
Thank you

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> ha scritto nel messaggio
news:uxzkLxSuFHA.1472 (AT) TK2MSFTNGP15 (DOT) phx.gbl...