dbsetup.sql: Sets up the database and tables with initial data. dynamicpivot.sql: Contains the main logic for creating dynamic pivot reports. storedprocedures.sql: Reusable stored procedures for ...

This is the server-side version of PowerPivot and works in conjunction with SQL Server 2008 R2. PowerPivot workbooks can be published using Excel Services for dynamic access via Sharepoint.