Unifier - Space Management / Primavera - Space Management
Description: Use this subject area to analyze space utilization for Facilities and Real Estate data from Primavera Unifier.
| Folder | SubFolder | Field Name | Dimension/ Fact / Lookup | Description (From Table) | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Level | General - (Level) | General Level | |||
| Level | General - (Level) | Level Name | Dimension | The name of the level | Value Derived From : Dim_W_LEVEL_D_Level.LEVEL_NAME |
| Level | General - (Level) | Level Status | Dimension | The status of the level | Value Derived From : Dim_W_LEVEL_D_Level.STATUS |
| Level | General - (Level) | Record Number | Dimension | The record number of the level | Value Derived From : Dim_W_LEVEL_D_Level.RECORD_NO |
| Space | General - (Space) | General Space | |||
| Space | General - (Space) | Record Number | Dimension | The record number of the space | Value Derived From : Dim_W_SPACE_D_Space.RECORD_NO |
| Space | General - (Space) | Space Name | Dimension | The name of the space | Value Derived From : Dim_W_SPACE_D_Space.SPACE_NAME |
| Space | General - (Space) | Space Type Name | Dimension | The type of the space | Value Derived From : Dim_W_SPACE_D_Space.SPACE_TYPE_NAME |
| Space | General - (Space) | Unit of Measure | Dimension | The unit of measure for the space | Value Derived From : Dim_W_SPACE_D_Space.UOM |
| Fact - Primavera - Space Management Folder | |||||
| Fact - Primavera - Space Management | Metrics - (Space) | Metrics - (Space) | |||
| Fact - Primavera - Space Management | Metrics - (Space) | # Of Space Records | Fact | # Of Space Records | count(distinct Fact_W_SPACE_F_Space.SPACE_WID) |
| Unifier Links Folder | |||||
| Unifier Links | Go to Unifier Links | ||||
| Unifier Links | Link to Level Log | Dimension | The link to the level log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Level"."Project Object Id" AS VARCHAR ( 10 )) || '&k=' || CAST ("P6Core"."Dim - Level"."Unifier Level Id" AS VARCHAR ( 10 )) || '&t=space' || '">' || 'Link to Level Log' || '</a>' | |
| Unifier Links | Link to Project | Dimension | The link to the project landing page in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticsproject">' || 'Link to Project' || '</a>' | |
| Unifier Links | Link to Space Type Log | Dimension | The link to the space type log in Unifier | '<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Space"."Project Object Id" AS VARCHAR ( 10 )) || '&k=' || CAST ("P6Core"."Dim - Space"."Unifier Space Id" AS VARCHAR ( 10 )) || '">' || 'Link to Space Type Log' || '</a>' |