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