Custom Units

Convert your items of measure to standard units. Arkieva natively handles standard unit conversions (i.e. pounds, grams, tons). If our data set consists of custom units, define the conversions to a standard unit and we'll handle the rest.

When creating a custom unit conversion, the amount of custom units will equal one standard unit. For example, a custom unit conversion could be 6 glass jars equaling 1 pound. 

When creating unit conversions, any items not included in the unit conversion sheet will have a 1-1 unit conversion for that custom unit. 

Assign data for ingestion of custom units

Custom Units can be used for data ingestion from Excel, SQL, and Arkieva Enterprise. 

To assign data for ingestion of custom units, each custom unit should be  table in the selected data source.

1. For file ingestion, the spreadsheet should be named 'Data'. 
   

To ingest an Excel spreadsheet, you can use just the file path for the spreadsheet.

To ingest a Comma Separated Values spreadsheet, the spreadsheet must only contain one page, the page must be named Data, and the file name must also be named Data.

The .csv must then be placed inside a folder without any other files, then that file path can then me used in the Remote File Type field.

• Related Articles

• Manage Units

  Manage the default display unit in the Demand module. CWT (cwt) Gigagram (Gg) Gram (g) Kilogram (kg) Kilopound (kip) Megagram (Mg) Microgram (μg) Milligram (mg) Change Display Unit Selecting a display unit will set that unit as the default display ...

• Custom Periods

  Custom Calendar Periods

• Custom Aggregations

  Create custom attributes to further organize data inputs to be displayed in tables, tree hierarchies, and data filters. Assign data for ingestion of custom aggregations Custom Aggregations can be used for data ingestion from Excel, SQL, and Arkieva ...

• Custom Reports

  Reports allow you to view the data associated with the end of the Demand, Inventory, and S&OP processes. You can view system created Official reports or create Custom reports. There is a 100000 limit to the creation of custom reports. To start ...

• Custom Calendar Period

  Under the custom Periods section, multiple custom calendars can be created. You can enter a custom period name and a start date for the custom calendar, and specify multiple sequential periods with names and end dates.