Support

support@facton.com
+49 1805-FACTON
Customer Portal

Imprint

Define Dimension Properties

Insert dimension properties for cost model reference data

  1. Select »Dimension Properties« in the Cost Model Reference Data view.
  2. In the ribbon, click on DATA ► Dimension Property in »Cost Model Reference Data« group to insert a dimension property.

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

  3. Define the details of the property in the Details view:
  4. Name Value
    Internal Name TableMainMaterialClassification
    Value Kind Reference Value
    Semantic Key Key
  5. Repeat step 1 to step 3 for the following dimension property:
  6. Name Value
    Internal Name TableArea
    Value Kind Unit Value

 

Cost Model Reference Data: Properties and Details view

The properties view differs in the context of the global signatures. The details view is also different for dimension properties and value properties.

  • Internal Name of the Property group

    The internal name is used as sheet name in the generated Excel file.

  • 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, plus one for the value and one for the unit. 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

    to generate a »_Left« and a »_Right« boundary. To define a range of values.

    Please consider the boundary logic below.

    2
    Reference Value mostly to reference a selection list, requires entering a semantic key 1
    Discrete Value 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 which must be selected correctly:

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

At least one dimension property and one value property must be created in order to generate a valid Cost#. If only one is specified, the global properties in the FACTON client are empty.