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>'

Related Topics