The Data Mapping - Level tab appears after you add Space Types, and it enables you to add custom level/floor fields, from various Levels, to use in Analytics. You can use this tab to map the Analytics field to the corresponding Levels field.
The Data Mapping - Level tab contains a list of user-defined attributes under the User Defined Attributes section. The User Defined Attributes section is a log that lists the following fields for each user-defined attributes:
- Name
- Data Type
- Data Source
- Label
All the fields mentioned above are read-only fields. You can add, modify, and remove user-defined attributes using the Add, Modify and Remove buttons on this tab.
Adding new user-defined fields
To add new user-defined fields, click Add to open the Add User Defined Attribute window and enter values in the following required fields:
- Data Type
- Name
- Data Source
- Label
About Data Type
The values for Data Type field are:
- String
- Date
- Numeric
When you select a Data Type, you set the value of the of the field as either a Dimension or a Fact. If you select the Data Type as String, or Timestamp, then the field will be a Dimension object in Analytics. If you select the Data Type as Numeric, then the field will be a Fact object in Analytics.
Data Type | Analytics |
|---|---|
String | Dimension |
Date | Dimension |
Numeric | Fact |
Adding new user-defined fields (custom fields) for Data Type: String
If you select the Data Type as String, then up to 20 String type Data Elements can be added from the Level Detail Form, as user-defined attributes.
To add new user-defined fields (custom fields) for String Data Type, click Add to open the User Defined Attribute window and enter values in the following required fields:
Name
The Name drop-down list contains values from “User Defined String Field 1" to "User Defined String Field 15.” If a name has already been selected, then the name is not listed in the Name drop-down list. For example, if the "Department" field has been added as a “User Defined String Field 1," then the Name drop-down list does not display “User Defined String Field 1." If a previously added field has been deleted, then that Name is displayed in the Name drop-down list.
Data Source
The Data Source drop-down list contains a list of Data Elements from the Level Detail Form.
If you select the Data Type as String, the Data Elements in the Data Source drop-down list are:
- Strings and Integer Pull Downs
- Integer and String Radio Buttons
- Check Boxes
- Test Data Elements
There are no Pickers listed/available. The Data Source field displays a series of interconnected Data Element names and Data Element labels in the following format: DE Label(DE name). For example, Project Type(prjt_type). If a previously added Data Element is deleted from the Deployed design, then the Data Element name is displayed, only.
Label
The Label field is populated based on the Data Element that you select in the Data Source. You can modify the value of this field with non-ISO characters (UTF-8), in order to support internationalization, only. The maximum allowed length is similar to Data Element label. The system does not perform a label uniqueness verification.
Adding new user-defined fields (custom fields) for Data Type: Date
If you select the Data Type as Date, then up to 10 "Date" Data Elements can be added from the Level Detail Form, as user-defined attributes.
To add new user-defined fields (custom fields) for Date Data Type, click Add to open the User Defined Attribute window and enter values in the following required fields:
Name
The Name drop-down list contains values from “User Defined Date Field 1" to "User Defined Date Field 10.” If a name has already been selected, then the name is not listed in the Name drop-down list. For example, if the "Project Commission Date" field has been added as a “User Defined Date Field 1," then the Name drop-down list does not display “User Defined Date Field 1." If a previously added field has been deleted, then that Name is displayed in the Name drop-down list.
Data Source
The Data Source drop-down list contains a list of Data Elements from the Level Detail Form.
If you select the Data Type as Date, the Data Elements in the Data Source drop-down list are:
- Date
- Date only Picker
The Data Source field displays a series of interconnected Data Element names and Data Element labels in the following format: DE Label(DE name). For example, Project Archive Date(prjt_arc_date). If a previously added Data Element is deleted from the Deployed design, then the Data Element name is displayed, only.
Label
The Label field is populated based on the Data Element that you select in the Data Source. You can modify the value of this field with non-ISO characters (UTF-8), in order to support internationalization, only. The system does not perform a label uniqueness verification.
Adding new user-defined fields (custom fields) for Data Type: Numeric
If you select the Data Type as Numeric, then up to 30 numeric data elements can be added from the Space Detail Form, as user-defined attributes.
To add new user-defined fields (custom fields) for Numeric Data Type, click Add to open the User Defined Attribute window and enter values in the following required fields:
Name
The Name drop-down list contains values from “User Defined Date Field 1" to "User Defined Date Field 30.” If a name has already been selected, then the name is not listed in the Name drop-down list. For example, if the "# of Spaces" field has been added as a “User Defined Date Field 1," then the Name drop-down list does not display “User Defined Date Field 1." If a previously added field has been deleted, then that Name is displayed in the Name drop-down list.
Data Source
If you select the Data Type as Numeric, the Data Elements in the Data Source drop-down list are the Data Elements found on the Level Detail Forms and are:
- Integer
- Currency
- Decimal Amount
There a no Integer Pull Downs, Integer Radio Buttons, and Integer Check Boxes. The Data Source field displays a series of interconnected Data Element names and Data Element labels in the following format: DE Label(DE name). For example, Contract Amount(con_amt). If a previously added Data Element is deleted from the Deployed design, then the Data Element name is displayed, only.
Label
The Label field is populated based on the Data Element that you select in the Data Source. You can modify the value of this field with non-ISO characters (UTF-8), in order to support internationalization, only. The maximum allowed length is similar to Data Element label. The system does not perform a label uniqueness verification.