Skip to main content

Analytics Cubes for InterSystems Supply Chain Orchestrator

This page describes the Business Intelligence cubes provided by InterSystems Supply Chain Orchestrator™. You can use these cubes in multiple ways, including:

  • To define KPIs

  • For simple exploration via the Business Intelligence tools provided within InterSystems IRIS®, such as the Business Intelligence Analyzer

  • To create pivot tables accessible via the Business Intelligence REST API

These cubes are available in the supply chain namespace. The cubes are available once you have loaded data into the supply chain tables, and the automated system tasks have built the analytics cubes.

Tip:

If the Analyzer is not available, make sure that the namespace is analytics-enabled.

Available Data

This section summarizes the data available in the analytics cubes.

Order Insights

Supply Chain Orchestrator provides data and tools needed for insights to all sales orders, including:

  • Order counts, total order revenue, mean/average revenue per order

  • Order fulfillment performance (on-time, in full, and so on)

  • By customers (region/country/company)

  • By product (category/family/brand/product)

  • By time (year/month/day)

  • By status

Similarly, for supply/purchase orders:

  • Order counts, total order revenue, mean/average revenue per order

  • Supplier performance

  • By supplier (region/country/company)

  • By product (category/family/brand/product)

  • By time (year/month/day)

  • By status

Shipment Insights

Supply Chain Orchestrator also provides the following information for shipments, both inbound and outbound:

  • Shipment count, shipment value

  • ETA and related status for in transit shipments

  • Performance for delivered shipments

  • By customer/supplier

  • By carrier, transportation mode, route, and so on

  • By origin, destination

  • By time (year/month/day)

Inventory Insights

Supply Chain Orchestrator also provides the following insights for inventories:

  • Stock levels: stock out, approaching stock out, excess inventory

  • Plan versus actual

  • By product (category/brand/etc.)

  • By location

Available Cubes

Supply Chain Orchestrator provides the following cubes:

  • SalesOrder cube. This cube is the primary source for sales order related information.

    • Measures: order count, total revenue, average order value, mean order value

    • Dimensions: customer (country -> name), sales region, order status, order placed date (year->month->day), ship status, delivery status.

  • SalesOrderLine cube. This cube supplements the SalesOrder cube, mainly to address any aspects related to product, such as revenue by product

    • Measures: total count, total value, total units

    • Dimensions: product category (category -> product), product brand (brand->product), ship status, delivery status

  • SalesShipment cube. This cube provides insights to sales order shipments.

  • PurchaseOrder cube. The source for purchase or supply order information.

  • PurchaseOrderLine cube. This cube supplements the PurchaseOrder cube, mainly to address any aspects related to product, such as cost or quantity by product.

  • SupplyShipment cube. Cube for supply shipment information.

  • Inventory cube. Cube for inventory related information.

Getting Started with the Cubes

Once you have loaded data into the supply chain tables, and the automated system tasks have built the analytics cubes, you can use the Analyzer to see the data. Consult Getting Familiar with a Subject Area to help you get acquainted with the cubes.

See Also

FeedbackOpens in a new tab