COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: Bern on 24 Feb 2009 08:44:08 AM

Title: Question about the surrogate keys.
Post by: Bern on 24 Feb 2009 08:44:08 AM
Hi everybody,

I've got a question about the surrogates keys.
Imagine you receive an unknown ID, and this ID is not in the specify dimension.

Can Data Manager insert this data in the Fact Table, without rejecting the key and then insert this key in the dimension table with a default value and a new surrogate key?

Thanks for your help! :)
Title: Re: Question about the surrogate keys.
Post by: UseCog on 28 Feb 2009 08:33:19 AM
it depends on the version of the data manager. If you are using 8.3 or 8.4, then you can accept those and directly insert into fact table.

~Best regards,
UG
Title: Re: Question about the surrogate keys.
Post by: Bern on 03 Mar 2009 02:56:25 AM
Quote from: UseCog on 28 Feb 2009 08:33:19 AM
it depends on the version of the data manager. If you are using 8.3 or 8.4, then you can accept those and directly insert into fact table.

~Best regards,
UG

Unfortunatly I use 8.2, so this option seem to be not available. :-\

Thanks again UseCog!
Regards!
Title: Re: Question about the surrogate keys.
Post by: UseCog on 03 Mar 2009 09:53:01 AM
you can derive some logic to do this... I can remember somebody have already answered this question in this forum. Please check
Title: Re: Question about the surrogate keys.
Post by: elealos on 03 Mar 2009 01:58:58 PM
You can write new values to the dim, assign a surrogate and deliver the new surrogate to the fact table on the fly. TO do so you will need a lookup that uses a template as the data source, and you will need to configure on the dimension element "allow unmatched" and "Save unmatched members via reference structure".
Title: Re: Question about the surrogate keys.
Post by: Bern on 05 Mar 2009 04:17:41 AM
Quote from: elealos on 03 Mar 2009 01:58:58 PM
You can write new values to the dim, assign a surrogate and deliver the new surrogate to the fact table on the fly. TO do so you will need a lookup that uses a template as the data source, and you will need to configure on the dimension element "allow unmatched" and "Save unmatched members via reference structure".

OK, thanks. So we can do something similar, but it's not inmediate.