Home » Developer & Programmer » Warehouse Builder » Type 2 dimension (OWB version 11.1.0.6.0, OWB Repository version - 11.1.0.1.1 on Windows)
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

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


Current Time: Thu Sep 29 10:50:41 CDT 2016

Total time taken to generate the page: 0.07591 seconds