Skip to end of metadata
Go to start of metadata
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 |
Measures Table
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 |
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 |
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 |
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 |