HansaWorld CRM

Dimension Table

Dimension	Dimension Hierarchy	Default properties
Time	Year / Quarter / Month / Week / Day
Customer	Category / Customer	Customer created date Customer updated date
Person	Sales Group / Person
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	Jira Code
Activity Class	Class / Type
Activity	Class / Type / Activity	Activity ID Type From Date To Date Creation Date Done Calendar Type Persons Customer Project Code Item code

Cube	Level	Measures
CRM	Record	Activity Duration Activity Count Activity OKed Duration Activity OKed Count Activity Not OKed Duration Activity Not OKed Count
Invoices (Shared)	Record	Invoice amount Discount amount Tax amount Invoice base amount Discount base amount Tax base amount Invoice count Invoice balance Invoice base balance
Invoices (Shared)	Item	Item amount FIFO Gross profit Item quantity Item base amount Gross profit base amount
Quotations (Shared)	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Quotation Discount amount Quotation Tax amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount Quotation Discount base amount Quotation Tax base amount Quotation count
Quotations (Shared)	Item	Quotation Item amount Quotation Item quantity Quotation Item base amount Quotation Gross profit Quotation Gross profit base amount
Sales Orders (Shared)	Record	Sales Order amount Sales Order Discount amount Sales Order Tax amount Sales Order base amount Sales Order Discount base amount Sales Order Tax base amount Sales Order count
Sales Orders (Shared)	Item	Sales Order Item amount Sales Order Item quantity Sales Order Item base amount Sales Order Gross profit Sales Order Gross profit base amount Sales Order Open amount Sales Order Open base amount Sales Order Open quantity