Published by ERP SPECIALISTS, INC.

Other products by ERP SPECIALISTS, INC.


This Sales Analysis SQL Query has been optimized for Power Pivot for Excel. The SQL Query delivers the result table that is used to drill down on the main KPI areas in SYSPRO. i.e. Branch, Area, Customer, Salesperson and Stock Code.


Version: 1.0

This Sales Analysis SQL Query has been optimized for Power Pivot for Excel.  The SQL Query delivers the result table that is used to drill down on the main KPI areas in SYSPRO i.e.  Branch, Area, Customer, Salesperson and Stock Code.

This is a SQL Query that is used in Power Pivot.  It is provided as part of the document included in the download.  Please note that it is not our intent to show you or teach you how to use Power Pivot for Excel. 

Power Pivot is a free add-in to the 2010 version of the spreadsheet application
Microsoft Excel and is a built-in functionality of Excel 2013.   As a self-service BI product Power Pivot is intended to allow users with no specialized BI or analytics training to develop data models and calculations.

http://www.microsoft.com/en-us/bi/powerpivot.aspx

This query is used in Power Pivot for Excel. 
Power Pivot works for both SQL and C-ISAM.
Download a free copy here.

http://www.microsoft.com/en-us/bi/powerpivot.aspx

The example used in this feature is a SQL Query. 
C-ISAM Users will need to create their own query using 
Microsoft Access and U-SQL drivers.

 

 

 

 

License type: Free
Pricing: Free