Custom Aggregations

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 Enterprise. 





To assign data for ingestion of custom aggregation, custom aggregate should be a 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.





  1. For SQL and Enterprise the custom aggregate should be 'Custom [Unit Name]'. You will need to replace the [Unit Name] of the data source table with the user entered unit name on the screen. In SQL, the structure should be like the image below. 
  2. To learn more about SQL data ingestion click here.





Composite Attributes





Composite attributes are used in systems where data needs to be represented at multiple levels of aggregation. In the context of Arkieva, the use of composite attributes can provide planners with a more flexible and detailed view of their data. The Arkieva application allows you to analyze data at multiple and different levels such as by item, location, or customer. This helps you perform more granular or broader analysis depending on your needs. Composite attributes enhance the ability to view and manage data from multiple perspectives, offering greater flexibility and insight for planning and decision-making.

Arkieva reads in the following data to create a corresponding table with these fields:
  1. Item Aggregate Attribute
  2. Item Aggregate Value
  3. Location Aggregate Attribute
  4. Location Aggregate Value
  5. Customer Aggregate Attribute
  6. Customer Aggregate Value
  7. Composite Attribute Value

Sample: 


Reserved keywords for naming custom attributes

  1. 'location'
  2. 'customer'
  3. 'item'
  4. 'item group'
  5. 'product hierarchy'
  6. 'location type'
  7. 'country'
  8. 'state'
  9. 'city'
  10. 'postal code'
  11. 'customer country'
  12. 'customer state'
  13. 'customer city'
  14. 'customer postal code'
  15. 'sales territory'
  16. 'sales area'
  17. 'sales organization'
  18. 'sales distribution channel'
  19. 'sales division'

    • Related Articles

    • Custom Periods

      Custom Calendar Periods

    • 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 ...

    • 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.

    • Overview

      Use Data Studio to: Configure a data source to import data Edit Master Data and review Transactional Data Create custom attributes Add custom unit conversions Add currency exchange rates Data Studio: Overview Data Studio facilitates management for ...