Sales Analysis Ad Hoc dashboard

The Sales Analysis Ad Hoc dashboard facilitates ad hoc analysis of a company’s revenue stream. Measures and attributes are available in Ad Hoc filters, providing a high degree of flexibility of what to analyze.

The dashboard contains these reports that display the measure selected in the Ad Hoc filter:

• Dynamic Metric History
• Dynamic Metric Ranking
• Dynamic Cross Table

You can filter the data by using these filters:

• Facility
• Warehouse
• By Date
• Year
• Measure Ad Hoc
• Row Ad Hoc
• Column Ad Hoc

Facility and Warehouse are standard filters; the other filters are embedded in the dashboard for easy access. The By Date filter provides a dynamic approach to analyzing the data in the dashboards by the different dates available in the Sales Analysis model. For instance, No. of Lines can be analyzed by invoice date, order date, delivery date, and entry date. The Dynamic Metric Ranking chart shows top ten items.

Source data and reports are documented in the Sales Analysis section.