Sales Dimensions
The Sales semantic model provides the following dimensions for slicing and filtering.
| Dimension | Description |
|---|---|
| Calendar | Dimension table for the default calendar |
| Calendar (DueDate) | Dimension table for due date calendar |
| Calendar (PromisedDate) | Dimension table for promised delivery date calendar |
| Calendar (RequestedDate) | Dimension table for requested delivery date calendar |
| Client | Dimension table for clients (legal entities) |
| CurrencySource | Dimension table for dynamic currency conversion: source currency of client |
| CurrencyTarget | Dimension table for dynamic currency conversion: target currency |
| CurrencyTransaction | Dimension table for transaction currency |
| DatabaseSource | Dimension table for source database |
| DataCategory | Dimension table for data category (e.g. actual or budget) |
| DataSource | Dimension table for data source (source table) |
| Dimension1 | Dimension table for financial dimension (placeholder 1) |
| Dimension2 | Dimension table for financial dimension (placeholder 2) |
| Dimension3 | Dimension table for financial dimension (placeholder 3) |
| Dimension4 | Dimension table for financial dimension (placeholder 4) |
| Dimension5 | Dimension table for financial dimension (placeholder 5) |
| Dimension6 | Dimension table for financial dimension (placeholder 6) |
| Employee | Dimension table for employees |
| InventLocation | Dimension table for invent locations |
| Invoice | Dimension table for invoices |
| InvoiceCustomer | Dimension table for invoice customers |
| Item | Dimension table for items |
| Item B (Basket Analysis) | Dimension Table for Items used as "Item B" - Dimension used for Shopping Basket Analysis |
| Order | Dimension table for orders |
| OrderCustomer | Dimension table for order customers |
| PaymentMethod | Dimension table for payment methods |
| PaymentTerms | Dimension table for payment terms |
| Quote | Documents with DocumentType "0" (Quote) |
| Resource | Dimension table for resources |
| SalesDocumentType | Dimension table for Document Types in CUB_Sales |
| SalesLineType | Dimension table for Types of Sales Line |
| Shipment | Dimension table for Shipment ID's |
| ShipmentMethod | Dimension table for shipment methods |
| Unit | Dimension table for units |