Skip to main content

Data Interface Requirements - Reference Measures

Written by Judi Zietsman

Reference Measures

File name

reference_measure_0.csv

Importance

Required

Description

Reference measure values used for forecasting, analysis, or reporting against specific products, locations, and optionally customer groups.

Criteria

  • Product Code and Location Code must exist in the app.

  • Customer Group is optional and must match the Customer Group setup in the app if provided.

  • Measure Date must be formatted as YYYY/MM/DD.

  • One record represents a single measure value for a specific product, location, customer group, and date combination.


Columns

Pos.

Name

Type

Importance

Description

1

Key Attribute 1

Char

Required

Product Code.

2

Key Attribute 2

Char

Required

Location Code.

3

Key Attribute...

Char

If Applicable

As an example, Customer Group, which can be configured in the app.

4

Measure Date

Date

Required

Date value in YYYY/MM/DD format.

5

Measure Value

Char

Required

Value to be inserted.


Example

WLE5301T,S1,TESCO STORES LTD,2024/01/15,100

Forget about these πŸ‘‡ 😞 😐 πŸ˜ƒ Have your say here!

Did this answer your question?