Model: Cash Planning - Specifications for Dimension Table: PROJECT WORK BREAKDOWN STRUCTURE

On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: PROJECT WORK BREAKDOWN STRUCTURE.

Contains the project work breakdown structure as a hiearchy.

Attributes

Attribute	Description (where applicable)
Company	Represents the Company connected to the project
Description	Represents the description of the ID column
ID	Id for a Project activity, Sub project or Project
Node Type	Represents the node type: “PROJECT”, “SUB PROJECT” or “ACTIVITY”
Project Id	Represents the Id for the project
Symbol n Description	# symbol added as prefix to the description for all rows with node type SUB PROJECT, all other rows have same value as in Description column.

Hierarchies

Hierarchy	Level
Work Breakdown Structure
	WBS01
	WBS02
	WBS03
	WBS04
	WBS05
	WBS06
	WBS07
	WBS08
	WBS09
	WBS10

USED BY MODEL(S)

Model Name

Cash Planning

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
PROJECT WORK BREAKDOWN STRUCTURE	DIM_PROJ_WORK_BREAKDOWN_STRUCT_TM	DIM_PROJ_WORK_BREAKDOWN_STRUCT_BI	DIM_PROJ_WORK_BREAKDOWN_STRUCT	On Line