Syntha Lab RU

Measures and dimensions reference

One row per measure: group, grain, unit, whether it adds up across slices, the currency conversion rule, the source and the owner. Needed so that the buying plan is fed with agreed facts.

Layouts for documents 8 columns 5 example rows

Download CSV ↓

What the template is for

Describing the data for buying planning and checking that the numerator and the denominator of a metric share one grain and one currency rule.

What one row is
one row = a measure

Columns

ColumnCodeTypeRequiredValidation rule
Measure namemeasureTextyesunique in the file
Measure groupgroupList valueyesbudget, order, receipt, sales, discount, stock, area or markup
GraingrainTextyeswhat one fact row means, not empty
UnitunitList valueyespcs, rub, pct, days, m² or k
Adds up across slicesadditiveList valueyesyes or no; shares and averages do not add up
Currency rulefxruleList valueyesnone, original, transaction_date or period_end
SourcesourceTextyesa system or a document
OwnerownerTextyesa role, not a surname

Example rows

Measure nameMeasure groupGrainUnitAdds up across slicesCurrency ruleSourceOwner
order_qtyorderorder linepcsyesnoneordering systembuyer
delivered_costreceiptdelivery × product × daterubyestransaction_datereceivingbuyer
sales_costsalesreceipt line × product × daterubyestransaction_datecash and accountingfinance
stock_end_qtystockproduct × place × daypcsnononewarehouselogistics
markup_coefmarkupproduct × price listknononeprice listcategory

The example data is illustrative: an exercise, replace it with your own.

Note

The currency rule transaction_date means the rate at the date of receipt or sale. Do not filter the sell-through denominator by the season calendar. The examples are illustrative.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →