How to Add Data Field in Data Source

Steps:

1. Select the Data Source.

2. Click the Add  icon to add a new data field.
   You can also use the Add Data Fields from Data Sample  option. For details see How to Import Data from Excel into Analytics.  

3. Select the Function of the field. 
   Not all fields must have a function, they can be left blank. The options are:

   • Alt-Key – This field is used when a source represents data that is to be optionally matched to Datamart rows using different fields.
     Example: The source ‘Customer Discount’ specifies a % discount to be applied to an invoice amount, either for a given customer or a customer group. A customer discount row may have either a Customer ID or a Customer Group ID field value, but not both. If these fields are defined as alt-keys, Pricefx will attempt to match rows using the key with the lowest rank first. If unsuccessful, the second, third etc. key will be attempted.

   • Level – This field is used when a source represents data on different, hierarchical levels.
     Example: The source ‘Product Discount’ specifies a discount of the list price to be applied for a given product; or in absence of such detail, for all products in a given product family; or a product line, etc. On Datamart refresh, using Level key fields, the system will first find rows with all level fields populated (and matching Datamart rows). Then it will try all rows where the lowest level (the one with the highest rank) matches, and so on.

   For Datamarts there are other function fields available:

   • Key –  This field is the primary key (marks if the line is unique). The source needs to have at least one key field, though more can be selected. Any non-numeric field can be part of the (composite) key. This field is important for updates of the data lines.
      Make sure you select here a field whose data do not contain national special characters. For details see Encoding.
     

   • Percent Basis – Field which is used as a percentage basis. It needs to be a money field (data type). All other money fields are calculated as a percent of this field.

   • Per Unit Basis – Field which is used to calculate the "per unit". It needs to be a quantity field (data type).

   • Pricing Data – Field which is used as a date. It needs to be a date field (data type).

4. Select the Data Type:
   

   • Number – Floating point number.

   • Quantity – Marks a field which contains the amount of products sold. The amount in this field will be taken into account for all fields marked "Per Unit" or "Extended". It makes sense to have just one Quantity field.

   • Text – String
     

   • Date – Data is formatted as a date.
     

   • Money – Data is formatted as money: contains a number which will be combined with the Currency field. Can be converted to a different currency.
     

   • Currency – Data is formatted as currency and are used for the conversion to other currencies. Only one Currency field is allowed. For details on currencies, see /wiki/spaces/KB/pages/22183992.
     

   • UOM – Unit of measure: data is a unit. These can be converted into another unit.
     

   • LOB – Data is a long string of text (up to 4000 characters). Data of this type cannot be used for grouping.
     

   • DateTime – Data is formatted as date and time. It is used in detailed time series.
     

   • Boolean – Data indicating false or true.

5. (Optional) Define the number format applied to the field (e.g., #,##0.00). Available only for numeric fields.
6. Set Name and Label. The Label is the usual representation of a field in the user interface. Field names are used in calculated field expressions (in a Datamart definition) and formula logic, as well as any integration configuration (Data Loads, exports…). Generally, a label change is cosmetic while a name change would require corresponding modifications wherever the field is used. A name must not contain any spaces or special characters (only [a..z], [A..Z] and [0..9] are allowed).

7. Select Measure indicating whether the data is a sum or a value per unit. This field is only necessary for data types Money and Number.

   • Per Unit – (Raw) data are available per unit. Such, the values are multiplied by the quantity to form a sum.

   • Extended – (Raw) data are the sum. Such, the values can be divided by the amount in order to calculate the value of each unit.

   • Fixed – Data and numbers are not multiplied by the quantity nor divided.

8. Define if the field can be used as a dimension in analytical charts and tables (only Text, Date, Currency, Integer, UOM and DateTime data types can be used as dimensions; for details on Integer click here).
   

9. (Optional) You can hide this field from the drop-down lists with variables (for axis, group-by, additional measure) in charts and rollups. 
10. Repeat the process until you have defined or changed all fields.
11. Optionally, you can validate the Data Source by clicking the Validate  icon.
12. Click the Deploy  icon to save and activate the Data Source (saving the Data Source as a draft is not possible). As soon as the Data Source is deployed, the Data Feed and Data Load are automatically generated.