HansaWorld core measures and dimensions

flex.BI core dimensions

flexBI imports and analyzes Hansaworld ERP registers (exported as source files or via REST) 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 (creation, posting, completion).
Customer	Business partner linked to Transactional Record.
Person	User/employee associated with Transactional Record.
Unit	Organizational or reporting unit (department, cost center, branch).
Currency	Transaction and reporting currency context.
Item	Inventory or sales item (SKU) from Items (INVc).
VAT Code	VAT/Tax code applied to transactions (VATCodeBlock).
Account	General Ledger account (AccVc).
Country	Country field from Contact/Customer card that is associated with Transactional Record.
Route	Delivery/visit route (DelRouteVc) where used.
Project (Job)	Projects/Jobs context (PRVc).
Location	Warehouse, store, or site (LocationVc).
Supplier	AP vendor linked to purchase documents.
Record Status	Transactional Record statuss (OKed, not-OKed).
Invoice	Invoice header (AR/AP).
Invoice Type	Invoice types (Normal, Cash, Credit, Downpayment).
Unpaid invoice periods	Aging buckets for outstanding AR/AP (e.g., 0–30, 31–60, 61–90, 90+ days) based on due dates and payment status.

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

flexBI core measures

Invoice Cube measures

flexBI 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 subtotal in original document currency, from invoice documents (IVVc).
Invoice base amount	Invoice subtotal converted to company base currency 1 (IVVc).
Invoice balance	Current outstanding (unpaid) invoice balance in original document currency from balances (ARVc/APVc) register.
Invoice base balance	Outstanding invoice balance converted to company base currency 1.
Discount amount	Total discount sum in original document currency from invoice rows (IVVc). Use for discount and promotion impact analysis.
Discount base amount	Total discount sum converted to company base currency 1 from invoice rows (IVVc). Use for discount and promotion impact analysis.
Tax amount	Total VAT/Tax amount in original document currency on invoices (IVVc). Use for VAT control and tax reporting.
Tax base amount	VAT/Tax row amount converted to company base currency 1 on invoices (IVVc). Use for VAT control and tax reporting.
Invoice count	Count of invoice records (IVVc). Use for volume KPIs and average value per invoice.
Invoice row count	Count of invoice rows. Used for average rows per invoice.
Unique invoice customers count	Number of distinct customers with at least one invoice in report context. Use for active customer base analysis.
Item amount	Item rows sum in original document currency from invoice rows (quantity multiplied by unit price minus line discounts).
Item base amount	Item sum from Invoice rows in Company base currency 1. Used to show Turnover, Revenue, Sales.
Item quantity	Item quantity from invoice rows, in the row unit.
Total weight	Invoice total weight for items sold.
Gross Profit	Gross profit from Invoice row items in company base currency 1.
Gross Profit Base Amount	Gross profit from Invoice row items in document original currency. Also called margin, profit, GP.