Dimensions

This section covers a brief description of the available dimensions within the Power BI semantic model. These dimension tables provide the master data attributes needed to analyze purchasing across various perspectives.

Calendar

Time dimension providing comprehensive date attributes including year, quarter, month, week, and day levels for temporal analysis.

Client

Company dimension for multi-tenant scenarios, containing client/company information.

CurrencySource

Source currency dimension for currency conversion scenarios.

CurrencyTarget

Target currency dimension for currency conversion scenarios.

DataCategory

Data categorization dimension for classifying transactions.

DataSource

Data source dimension identifying the origin of transaction data.

DatabaseSource

Database source identification for multi-source scenarios.

Dimension 1-6

Flexible dimension attributes (Global Dimensions and Shortcut Dimensions) from Business Central for custom analysis perspectives.

Employee

Employee master data for analyzing responsibilities (e.g., purchaser).

Invent Location

Warehouse/location master data, essential for inbound logistics analysis.

Item

Item/product master data with attributes such as categories and replenishment settings relevant for procurement.

Payment Method

Payment method settings used on purchase documents.

Payment Terms

Payment terms for due date calculations and document conditions.

Purchase Document Type

Document type classifier (Order, Receipt, Invoice, etc.) used to group purchasing transactions.

Purchase Line Type

Line type classifier (Item, G/L Account, Resource) for purchase lines.

Purchase Invoice

Invoice header identifiers and external references for invoice-level analysis.

Purchase Order

Order header including order number and status for order-level analysis.

Resource

Resource master data for non-item purchase lines.

Shipment Method

Shipment method settings used on purchase documents.

Time Intelligence

Calculation group providing PY/YoY variants for time-based comparisons.

Unit

Unit of measure dimension for quantity conversions.

Vendor

Vendor master data including address and contact information for supplier analysis.