microsofttrends.com
Sometimes an Ordinary Pivot Table is Faster/Better than PowerPivot - Microsoft Trends
One of the ways to interact with a SSAS cube is through an ordinary Excel Pivot Table. You can do this by the following steps: 1. Insert Pivot Table 2. Select “Use an external data source”. 3. Choose or create a connection to your SQL SSAS cube. Once you have established your connection, you can …