Can I read Sales Order Shipments Analysis Query on EtoBox?
Sales Order Shipments Analysis Query by Ahad Sultan is a document available to read on EtoBox.
What is Sales Order Shipments Analysis Query about?
This query selects the calendar year, calendar quarter, customer name, sum of extended cost, and invoice count from the Inventory_fact, date_dim, and cust_vendor_dim tables where the transaction type key is 5, the date key matches between tables, and the calendar year is 2011 or 2012, grouping the results by cube on name, calendar year and calendar quarter and ordering by calendar year, calendar quarter, and name, returning 189 rows.
- Author
- Ahad Sultan
- Language
- EN