Purchase Dimensions
The Purchase semantic model provides the following dimensions for slicing and filtering.
| Dimension | Description |
|---|---|
| Calendar | Dimension table for the default 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 |
| 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 |
| Item | Dimension table for items |
| PaymentMethod | Dimension table for payment methods |
| PaymentTerms | Dimension table for payment terms |
| PurchaseInvoice | |
| PurchaseOrder | |
| PurchDocumentType | |
| PurchLineType | |
| Resource | Dimension table for resources |
| ShipmentMethod | Dimension table for shipment methods |
| Unit | Dimension table for units |
| Vendor |