AnsweredAssumed Answered

OBS Query

Question asked by Owen_R on Jan 9, 2012
Latest reply on Jan 9, 2012 by another_martink
Hi all and happy new year to you

I need some help querying the live OBS tables.

We have a resource OBS which has a structure like this: Top | Professional Family | Country | Site

All resources are mapped to at least country, but typically site level. For a given resource I want to be able to retrieve the value at the Professional Family level and not the lowest level.

Ordinarily I would go straight to NBI_RESOURCE_CURRENT_FACTS / NBI_DIM_OBS and get the value from LEVEL2_NAME but in this case I want the data to be real-time not datamart based.

Has anyone got any SQL that allows me to pick the data from a higher level of the OBS for a given resource, in real time? I'm struggling trying to query PRJ_OBS_UNITS, PRJ_OBS_UNITS_FLAT and OBS_UNITS_FLAT_BY_MODE but I'm assuming the answers are in here somewhere.