Clarity: Technical Reference Guide shows Tables 'PRJ_OBS_REPORTING' and 'PRJ_OBS_LABELS'. No data appears in these tables. Why?

Document ID : KB000050111
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The Clarity Technical Reference Guide shows information for two tables: 'PRJ_OBS_REPORTING' and 'PRJ_OBS_LABELS'

These tables appear to have a purpose for use in reporting. If we query the tables no data is returned. How are these tables populated and where is the data used in the application?

Clarity Technical Reference Guide:

PRJ_OBS_REPORTING

This denormalized table is used for reporting and stores the names of all the levels that are parents of a given organizational breakdown structure (OBS) unit. Only levels that are above the unit have valid values.

PRJ_OBS_LABELS

This denormalized table is used for reporting and stores the names of all the levels in an organizational breakdown structure (OBS).

Solution:

These two tables are obsolete and not used in the application or in any stock portlet or report. If you examine the table structure of these two tables you will see that the data is available in the NBI_DIM_OBS table. The NBI_DIM_OBS table is populated by the 'Datamart Extraction' job and the 'Update Business Objects Tables' job (by selecting the 'Populate OBS' parameter).

NBI_DIM_OBS

This dimension table stores organizational breakdown structure (OBS) unit information. This table is populated by extracting data from PRJ_OBS_TYPES and PRJ_OBS_UNITS during the datamart extraction.

STATUS/RESOLUTION:

This issue has been logged as a documentation defect CLRT-65132 which will be reviewed for updates in a future release.

Keywords: CLARITYKB, CLRT-65132, how-to, documentation, schema.