0 Replies Latest reply: Sep 9, 2013 9:10 AM by user2779342 RSS

    Orphan management in cubes

    user2779342

      Hi, I’m using Oracle Warehouse builder 11.2.0.3.

       

      I want to fill a cube, and I have 2 problems:

       

      1)     1) In cube policies setting (in a mapping, when I select my cube) I selected ‘Default Dimension Record’ for both ‘Load Policy for invalid key’ and ‘Load policy for null key’.

      In my dimensions I did not specify any default value.

      After execution of the mapping, in the table behind the cube it inserts ‘-1’, even when there is no record in the dimension with ‘-1’ surrogate key!

      I want it to insert ‘NULL’ instead of ‘-1’ and I don’t know how…

       

      2)     2) In cube policies when I want to select anything but ‘No maintenance’ I have to enable error table in cube settings. What if I don’t want to log any errors to any error table? And when I change ‘Record error rows’ to ‘no’ (In mapping, when cube is selected), it still inserts rows to error table.

       

      Thanks