Define Dimension Properties

Insert dimension properties for reference data

1. Select »Dimension Properties« in the Reference Data view.
2. In the ribbon, click on DATA ► Dimension Property.

   Alternative: Right-click on »Dimension Properties« ► Dimension Property.

3. Define the details of the property in the Details view:

Name	Value
Internal Name	TableMainMaterialClassification
Value Kind	Reference Value
Semantic Key	Key

4. Repeat step 1 to step 3 for the following dimension property:

Name	Value
Internal Name	TableArea
Value Kind	Unit Value

• Value Kind

  The value kind property is used to generate an Excel file which can be filled with data.

  Dimension Properties

  Value Kind	Description	#Columns
  Unit Value	Is a Continuous Value. Is used to generate two columns- one for the value and one for the unit. Is used to define a range of values with units. Example: When the main material is hard wood and the table area is between 0 m² to 1 m², the table height should be XX mm.	4
  Continuous Value	Is used to generate a »_Left« and a »_Right« boundary and to define a range of values. Define a range of values. Please consider the boundary logic below.	2
  Reference Value	Is mostly used to reference a selection list. It requires entering a semantic key.	1
  Discrete Value	Is used to generate a single column in the Excel file.	1

  Boundary logic for continuous types of dimension properties:

  While dimension property values of type »Tree« match by simple comparison (possibly hierarchical), the other – continuous – types use intervals for matching. The following logic regarding boundaries applies:

  For properties of type Date both the left-hand and the right-hand date value are fully included in the interval, e.g. [1/1/2015, 12/31/2015] is the same as [1.1.2015 00:00 UTC, 31.12.2015 24:00 UTC). This value rule would match on the 1st of January and on the 31st of December, regardless of clock time.

  For all other continuous types (Number or unit types like Length), the left-hand value is included in the interval, the right-hand value is not. So, if you have two intervals [0%,10%] and [10%,20%], they will not overlap. For a dimension value of 9.999%, the first interval (rule) will match, for a value of 10% the second interval (rule) will match.

  Value Properties

  Depending on the type, there are the following value kinds to be correctly selected:

  Type	Value Kind	Description
  Number, Text, ...	Discrete Value	Is used to generate a single column in the Excel file.
  LocalizedText	Localized Value	Is used to generate the columns for all languages.
  Unit value1 Unit Value consists of number value and unit part (e.g. Length)	Unit Value	Is used to generate two columns- one for the value and one for the unit.
  TTree (Selection List)	Reference Value	Is mostly used to reference a selection list. It requires entering a semantic key.