SO hold star schema grouping

Dimensions

• Calendar
• Enterprise
• Seller
• Buyer
• Channel
• Hold type
• Document type
• Customer
• Customer hierarchy

Measures

The SO Hold measure is Hold Duration. This field indicates the duration of hold applied on an order (in minutes).

Grouped measures

The following table provides a list of the SO Hold grouped measures:

Measure

Description

No. of Orders on Hold

This is the total number of orders on hold.

Avg. Hold Duration

This is the average time the orders are kept on hold.

Hold Duration For Open Holds

This is the time elapsed in minutes from hold creation date to current date, on the orders that are kept on hold, with open or rejected hold status.