HansaWorld core measures and dimensions

flex.bi core dimensions

flex.bi imports and analyzes Hansaworld ERP registers with REST API and organizes records into shared analytical dimensions.

Transactional Record (or operational document) in this context refers to any entry in a register that tracks a live business action like Invoice, Sales Order, Activity, Item History, Delivery, Transaction, Goods Receipt, Point of Sale, Purchase Invoice, Purchase Order, Quotation, Stock Depreciation, Stock Movement.

Dimension	Description
Time	Transactional Record date.
Week Day	Days of the week.
Hour	Hour-of-day from Transactional Record timestamps.
Customer	Customer for theTransactional Record.
Person	User/employee associated with Transactional Record.
Unit	Measurement unit used for items such as kg, meters, cm, liters, etc.
Currency	Currency used in the Transactional Record.
Item	Related items (INVc). Usually listed in Transactional Record rows. Record level measures don’t work with this dimemsnion.
VAT Code	VAT/Tax code (VATCodeBlock).
Account	Nominal Ledger account (AccVc).
Country	Country field from Contact/Customer card that is associated with Transactional Record.
Route	Delivery/visit route (DelRouteVc).
Project (Job)	Projects/Job (PRVc).
Location	Warehouse, store, or site (LocationVc).
Supplier	Supplier for purchase documents.
Record Status	Transactional Record status that shows if the “OK” checkbox was checked (OKed, not-OKed).
Invoice	Shows specific invoices and can be expanded to show the invoice items.
Invoice Type	Invoice types (Normal, Cash, Credit, Downpayment, Normal Special Sales, Credit Special Sales).
Unpaid invoice periods	Age range for outstanding/unpaid invoices (e.g., 0, 1–15, 16–30, 31–45, 46-60, 166+ days) based on due dates and payment status. The period ranges can be changed in import settings.

Invoice Dimension Property

Properties in table below can be used if Invoice dimension is placed in rows.

Level	Property name
Invoice	Invoice date
	Invoice type
	Customer code
	Customer name
	Person code
	Project code
	Sales group code
	Due date
	Currency
	Currency rate
	Invoice to Customer Code
	Invoice to Customer Name
	Invoice transaction time
	URL
Invoice Item	Invoice item type
	Item code
	Objects
	Item Varieties

flex.bi core measures

Invoice Cube measures

flex.bi calculates numeric measures from Hansaworld / StandardERP / Standard Books registers (Sales Lager). Most measures are available both in transaction currency and in company base currency 1 (BaseCurBlock).

Measure	Description
Invoice amount	Invoice (IVVc) total amount in original document currency, from invoice documents.
Invoice base amount	Invoice (IVVc) total amount converted to company main base currency.
Invoice balance	Current outstanding (unpaid) invoice balance in original document currency from balances (ARVc) register.
Invoice base balance	Outstanding invoice balance converted to company main base currency from balances (ARVc) register.
Discount amount	Total discount sum in original document currency from invoice (IVVc).
Discount base amount	Total discount sum converted to company main base currency from invoice (IVVc).
Tax amount	Total VAT/Tax amount in original document currency on invoices (IVVc).
Tax base amount	VAT/Tax row amount converted to company main base currency on invoices (IVVc).
Invoice count	Count of invoice (IVVc) records.
Invoice row count	Count of Invoice (IVVc) record rows.
Unique invoice customers count	Number of distinct customers with at least one Invoice (IVVc) in report context.
Item amount	Invoice (IVVc) rows Item sum in original document currency.
Item base amount	Invoice (IVVc) rows Item sum in company main base currency. Used as primary measure for Turnover, Revenue, Sales, etc.
Item quantity	Invoice (IVVc) rows Item quantity.
Total weight	Invoice total weight from sold items.
Gross Profit	Invoice (IVVc) rows Item gross profit in company main base currency.
Gross Profit Base Amount	Invoice (IVVc) rows Item gross profit in company main base currency. Used as primary measure for Margin, Profit, GP, etc.