| Key | Value |
|---|---|
| Table | DS02 OBS |
| Severity | CRITICAL |
| Unique ID | 1020047 |
| Summary | Is the root of the OBS hierarchy (Level 1) unique? |
| Error message | OBS hierarchy contains more than one Level 1 OBS element. |
The Data Integrity and Quality (DIQ) check titled "Root of OBS Not Unique" is designed to ensure that the root of the Organizational Breakdown Structure (OBS) hierarchy, also known as Level 1, is unique within the DS02 OBS table.
To resolve this issue, review the data in the DS02 OBS table to ensure that only one element is assigned to Level 1 and that each OBS element is unique.
This test is being performed to ensure that the root of the Organizational Breakdown Structure (OBS) hierarchy is unique. The OBS is a hierarchical arrangement of a project's management structure, and it is crucial for it to have a unique root (Level 1) to avoid confusion and maintain a clear chain of command and responsibility.
The severity of this test is marked as 'CRITICAL', which is the highest level of severity. This means that if the OBS hierarchy contains more than one Level 1 OBS element, it is a critical issue that must be fixed before the data can be reviewed.
The importance of this check lies in maintaining the integrity and clarity of the project's management structure. Having more than one root in the OBS hierarchy could lead to confusion, miscommunication, and inefficiency in project management. It could also cause problems during data analysis, as it might not be clear which root element should be used for certain calculations or decisions. Therefore, ensuring the uniqueness of the OBS root is crucial for the successful management and analysis of the project.
CREATE FUNCTION [dbo].[fnDIQ_DS02_OBS_IsOBSRootRepeated] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT *
FROM DS02_OBS
WHERE upload_ID = @upload_id
AND [Level] = 1
AND (
SELECT COUNT(*)
FROM DS02_OBS
WHERE upload_ID = @upload_id
AND [Level] = 1
) > 1
)