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 demand planning facts 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.

Customer

Customer master data including address, location, and contact information for demand analysis by customer.

DatabaseSource

Database source identification for multi-source scenarios.

DataCategory

Data categorization dimension for classifying transactions.

DataSource

Data source dimension identifying the origin of transaction data.

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, salesperson).

Invent Location

Warehouse/location master data, essential for location-specific demand and supply planning.

Invent Transaction Status

Status classification of inventory transactions (receipt, issue, transfer).

Invent Trans Type

Type classification of inventory transactions (sales, purchase, production, etc.).

Invent Voucher

Voucher reference dimension for inventory transaction grouping.

Item

Item/product master data with comprehensive attributes including item categories, replenishment parameters, and hierarchies.

Production Order

Production order master data including status, source type, and production order details.

Production Order Line

Production order line details for analyzing production planning at line level.

Purchase Order

Purchase order master data including order status and identification.

Sales Order

Sales order master data including order status and identification.

Stockkeeping Unit

Stockkeeping unit (SKU) master data with item-location specific replenishment parameters including reorder point, safety stock, lead times, and ABC/XYZ classification.

Unit

Unit of measure dimension for quantity conversions.

Vendor

Vendor master data including address, location, and contact information for supply analysis by vendor.