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

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

Contains the project cost breakdown structure as a hiearchy.

Attributes

Attribute	Description (where applicable)
Company Code	Represents the Company connected to the project
Cost Structure Id	Represents the Id for the Cost Structure
Description	Represents the description of the Name Value
ID	Built as PROJECT ID ^ COMPANY CODE ^ NAME VALUE
Project Id	Represents the Project Id
Structure Child	Structure Child
Structure Parent	Structure Parent
Unique Item Above	Structure Above

Hierarchies

Hierarchy	Level
Cost Breakdown Structure
	CBS01
	CBS02
	CBS03
	CBS04
	CBS05
	CBS06
	CBS07
	CBS08
	CBS09
	CBS10

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 COST BREAKDOWN STRUCTURE	DIM_PROJ_COST_BREAKDOWN_STRUCT_TM	DIM_PROJ_COST_BREAKDOWN_STRUCT_BI	DIM_PROJ_COST_BREAKDOWN_STRUCT	On Line