Sales Orders Ad Hoc reports

In case of changes to the Metric Ranking report, review the report expressions Cut-off Count and Sort Order in Visualizer.

Select a value in the currency filter to avoid adding up amounts in different currencies.

The measures used in Sales Orders Ad Hoc reports are sourced from the Sales Orders fact. These measures use the Sum aggregation.

Metric Ranking

Measure: Dynamic selection of measures with Metric Ad Hoc – CO filter

Chart type: 1 data series bar chart with dynamic selection of attribute available in Row Ad Hoc filter

Filter information: Ranking is a mandatory filter; the user can select top/bottom. Report expressions Cut-off Count and Sort Orders are used in ranking the attributes.

Parameters used in the report: Metric, Date, Row, Ranking

Order Value Table

Measure: Order Value – Company, Order Value – Division, Order Value – Transaction, Line Amt – Company, Line Amt – Division, Line Amt – Transaction, Order Qty

Chart type: Table with dynamic selection of attribute in Row Ad Hoc – CO filter

Filter information: The Currency Type filter enables the user to switch between amounts in company, division and transaction currency.

Parameters used in the report: Date, Row, Currency Type

Order Quantity Table

Measure: Order Qty, Qty not Delivered, Qty not Invoiced, Allocated Qty, Picking List Qty, Delivered Qty, Invoiced Qty

Chart type: Table with dynamic selection of attribute in Row Ad Hoc – CO filter

Parameters used in the report: Date, Row