Re: Handling slow changing dimension
- From: "darkeagle" <darkeagle@nospam>
- Date: Wed, 14 Sep 2005 15:32:41 +0200
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_@xxxxxxxxxxxxxx> ha scritto nel messaggio
news:uxzkLxSuFHA.1472@xxxxxxxxxxxxxxxxxxxxxxx
> 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 in message
> news:43280018$1_1@xxxxxxxxxxxxxxx
>>I forgotten, I must do this with analisys services 2000.
>> Thank you.
>>
>> "darkeagle" <darkeagle@nospam> ha scritto nel messaggio
>> news:4327ff44_2@xxxxxxxxxxxxxxx
>>> 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
>>>
>>
>>
>
>
.
- References:
- Handling slow changing dimension
- From: darkeagle
- Re: Handling slow changing dimension
- From: darkeagle
- Handling slow changing dimension
- Prev by Date: AS2005 - Rolling Up Namesets
- Next by Date: RE: median as a derived measure
- Previous by thread: Re: Handling slow changing dimension
- Next by thread: unary rollup and solve order
- Index(es):
Relevant Pages
|
Loading
