Home » Developer & Programmer » Warehouse Builder » Type 2 dimension (OWB version, OWB Repository version - on Windows)
Type 2 dimension [message #422516] Thu, 17 September 2009 00:53
Messages: 1
Registered: September 2009
Junior Member

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.


[Updated on: Thu, 17 September 2009 02:31]

Report message to a moderator

Previous Topic: Process flow condition help
Next Topic: Oracle 9i OLAP Tutorial
Goto Forum:

Current Time: Thu Oct 20 15:37:58 CDT 2016

Total time taken to generate the page: 0.20031 seconds