Type 2 dimension [message #422516] |
Thu, 17 September 2009 00:53 |
Shikha_ACL
Messages: 1 Registered: September 2009
|
Junior Member |
|
|
Hi,
I created a TYPE 2 dimension in OWB where ID (dimension_key) is a surrogate identifier hence auto-generated by OWB, user_id as bussiness identifier, effective_date - When user registered and expiration_date - When user edit his profile.
I have inserted a manual record in the dimension but OWB is neglecting the inserted record. Can anybody please tell - why OWB is acting like this and what is the other way-out if I have to insert manual records in TYPE 2 dimension.
Shikha
[Updated on: Thu, 17 September 2009 02:31] Report message to a moderator
|
|
|