AnsweredAssumed Answered

NBI_DIM_OBS

Question asked by ben.jones on Feb 26, 2013
Latest reply on Feb 26, 2013 by ben.jones
Can anyone tell me what this table does?

NBI_DIM_OBS

We're using it to return obs details for projects using this sql but it looks like it's returning old data:

SELECT i.code,
Record_ID,
LEVEL1_NAME,
LEVEL2_NAME,
LEVEL3_NAME,
LEVEL4_NAME,
LEVEL5_NAME

FROM niku.NBI_DIM_OBS obs,
niku.PRJ_OBS_ASSOCIATIONS asoc,
niku.inv_investments i
WHERE obs_type_name = 'Portfolio'
AND obs.obs_unit_id = asoc.unit_id
and asoc.unit_id = i.id

Outcomes