Order Information by Product

You access this report in one of these ways:

• By clicking the heading of the Order Information metric in the Procurement dashboard and selecting by Item
• By clicking Items below 'Number of:' in the Order Information metric
• By clicking the Settings button in the table heading one of the other order information reports, selecting Select dimension, and selecting Product in the Select Dimension dialog
• By clicking a dimension element in one of the order information reports and selecting from the menu

The view of the data is filtered by these hierarchies:

• Order time
• Delivery time
• Product
• Ship-from
• Ship-to
• Purchase Office
• Buyer
• Order reference
• Status

To change your view of the data, select from the filter lists. If the lists are not displayed, click the down arrow in the report heading.

The Product hierarchy is selected in the heading of the data table. Each element of the hierarchy forms a row of the report.

You can expand the hierarchy and drill down to view the data at any level.

For each row, the report shows this information:

• Order amount
• Order quantity
• Unit price
• Number of order lines
• Average order line amount
• Number of suppliers
• Number of buyers
• Number of Purchase Offices

If a Item is a base element, the Base Unit of Measure is displayed.

If you access the report from the Procurement dashboard then, by default, the complete Product hierarchy is selected. You can instead restrict the hierarchy to, for example, the top or bottom 5 Items, measured by one of these metrics:

• Order amount
• Order quantity
• Unit price
• Number of order lines
• Average order line amount

To restrict the hierarchy, click Complete Hierarchy and select Top Count or Bottom Count. From the Cut off list, select the number of Items to view. From the Filter by list, select a metric.

If you enable a top count, the elements of the hierarchy are sorted in descending order, by value and the selected measures. For example, the top 5 elements by order amount displays the five elements with the highest order amount first, and the lowest order amount last. A count of the bottom 5 elements by order amount displays the element with the lowest order amount first.

If you access the report from one of the other order information reports, in which you have restricted the hierarchy, the same restriction is automatically applied. To view the complete hierarchy, select Complete Hierarchy.

To access the linked reports, click the Settings icon in the table heading, select Select dimension and select from the Select Dimension dialog. Or click an element in the table and select from the menu.