HansaWorld Job Costing

HansaWorld Job Costing cube demo

Dimension Table

Dimension	Dimension Hierarchy	Default properties
Time	Year / Quarter / Month / Week / Day
Customer	Category / Customer	Customer category Customer person code Customer classification
Person	Sales Group / Person
Currency	Currency
Item	Group / Item
Project (Job)	Class / Project / Project item	Project customer Project status Project manager Project person Project sales group Project start date Project end date Project finished date
Jira Code	Jira Code

Measures Table

Cube	Level	Measures
Activity level ???	Record	Activity Duration Activity Count Activity OKed Duration Activity OKed Count Activity Not OKed Duration Activity Not OKed Count
Item budget ???	Item	Item budget amount Item budget base amount Item budget quantity Budget Gross profit Budget Gross profit base Budget discount amount Budget discount base amount Item budget count
Invoice (Shared)	Record	Invoice amount Invoice Discount amount Invoice Tax amount Invoice base amount Invoice Discount base amount Invoice Tax base amount Invoice count Invoice balance Invoice base balance New customer count
Invoice (Shared)	Item	Invoice Item amount Invoice FIFO Invoice Gross profit Invoice Item quantity Invoice Item base amount Invoice Gross profit base amount
Quotation (Shared)	Record	Quotation amount Quotation base amount Quotation Discount amount Quotation Discount base amount Quotation Tax amount Quotation Tax base amount Quotation count
Quotation (Shared)	Item	Quotation Item amount Quotation Item quantity Quotation Item base amount Quotation Gross profit Quotation Gross profit base amount
Sales Order (Shared)	Record	Sales Order amount Sales Order base amount Sales Order Discount amount Sales Order Discount base amount Sales Order Tax amount Sales Order Tax base amount Sales Order count
Sales Order (Shared)	Item	Sales Order Item amount Sales Order Item base amount Sales Order Item quantity Sales Order Gross profit Sales Order Gross profit base amount
Project level ???		Project budget amount Project budget base amount Project count