Horizon core measures and dimensions

Time

Transactional Record date.

Customer

Customer for the Transactional Record.

Project

Project.

Invoice

Shows specific invoices and can be expanded to show the invoice items.

Invoice Status

Invoice status shows if invoice is prepared, completed, posted.

Item

Related items. Usually listed in Transactional Record rows. Record level measures don’t work with this dimension.

Sales Person

User/employee associated with Transactional Record.

Invoice Currency

Currency used in the Transactional Record.

Document Type

Document types.

Account

Accounting account.

Department

An organizational structural element used for analytical data recording, personnel management, and financial segmentation.

Transaction

Transactional Record.

Manufacturer

Manufacturer for transactional records.

Detailed Age group

Age groups for employees.

Education Level

Employees education level.

Employee

Employee.

Profession

The employee's profession/occupation classification.

Salary Payment Type

Classifies salary/payment records by type (e.g. base salary, bonus, allowance payment type).

Employee Department Group

Groups employees by department at a higher, simplified level (separate from the Employee dimension's own department levels).

Employee Gender

Gender of the employee (has a calculated "both genders" member for combined totals).

Employee Position

Employee's job position/title.

Employee Payment Type

Classifies employees by their payment arrangement type (e.g. hourly, monthly salary).

Employee Age group

A more granular age bucketing, with an additional Year level (likely age group as of a specific year).

Employee Years in Company Group

Employees bucketed by tenure length (years in the company) ranges.

Employee Years Before Leaving

Employees bucketed by how many years they worked before leaving the company (relevant for former employees).

Batch

Location

Warehouse, store, or site.

Stock Document

Individual stock documents (e.g., goods receipts, transfers, write-offs).

Supplier

Supplier for purchase documents.

Stock Document Type

The type of stock document (e.g., incoming, outgoing, transfer).

Stock Document Status

The status of a stock document (e.g., draft, posted).

Invoice

Invoice name

Invoice due date

Document type code

Document type name

Invoice item

Invoice item name

Invoice Addition name

Invoice item name value

Customer

Customer name

PVN Registration No

Project

Project name

Projekta vadītājs

Projekta apraksts

Statuss

Likme

Project

Document Reg No

Document name

Invoice Amount

The invoice amount, reflecting the total value of the invoice in the original document currency (NDOK.D.SUMMA_PV).

Invoice Count

The number of invoices, showing the total quantity of recorded invoices.

Invoice Item Amount

Item amount in the original document currency from invoice rows (quantity × unit price minus line discounts; typically excluding VAT) (NDOK.SUMMA, rows). Also called Turnover, Revenue, Sales.

Invoice Item Price

The invoice item price per unit for the specific product or service. (NDOK.CENA, rows)

Invoice Item Quantity

Total item quantity from invoice rows, in the row unit (NDOK.DAUDZ, rows)

Invoice Prepayment Amount

The prepayment amount related to the invoice. (NDOK.D.SUM_PAPM)

Invoice Prepayment Tax Amount

The prepayment tax amount calculated for the prepayment. (NDOK.D.SUM_PPVN)

Invoice Tax Amount

The invoice tax amount, indicating the total applied taxes for the invoice. (NDOK.D.SUMMA_PVN)

Invoice Due Date

Due date (calculated measure), reflecting the final payment date of the invoice in the analysis (NDOK.D.APM_TERM (date)).

Invoice Item Cost amount

Cost amount associated with the item.

Balance

The monetary net worth, value, or cumulative standing of a specific financial account at a given point in time or over a defined period.

Credit

The total numeric value of all financial transactions recorded on the right side of the general ledger for a given period and account.

Debit

The total numeric value of all financial transactions recorded on the left side of the general ledger for a given period and account.

Employee Left Count

Counts employees who left the company. Calculated from employee rows and bound to the Time dimension by employee end date.

Employee Joined Count

Counts employees who joined the company. Calculated from employee rows and bound to the Time dimension by employee start date.

Employee Age Measure

Employee age measure based on age in years. For leaving rows, the value is written as a negative age value to support net calculations.

Amount

Salary payment amount from TAB.SUMMAVAL1.

Deducted Amount

Deducted salary amount from X.IETUR.

Payed Amount

Paid salary amount from X.SAMAK.

Transaction Count

Counts salary payment transactions. Calculated via JavaScript and excludes employee records with codes ending in _DX.

Education Level Count

Counts employee education level records when an education level code is available.

Base Salary Change Count

Counts base salary and profession change records. Excludes employee records with codes ending in _DX.

Base Salary

Base salary amount from SUMMA.

Base Salary Deduction

Negative base salary amount created after the salary end date. The end date is shifted forward by one day and SUMMA is multiplied by -1.

Available Quantity

Quantity currently available (not reserved).

Current Amount

Current stock value (monetary).

Current Quantity

Current quantity on hand.

Reserved Quantity

Quantity reserved (e.g., for pending orders).

Status Record Count

Count of stock status records.

Stock In Amount

Value of stock received.

Stock In Quantity

Quantity of stock received.

Stock Out Amount

Value of stock issued.

Stock Out Quantity

Quantity of stock issued.