Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
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 ??? | | Activity Duration Activity Count Activity OKed Duration Activity OKed Count Activity Not OKed Duration Activity Not OKed Count |
Item budget ??? | | 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 |
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 |
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 |
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 |