Title: PivotTable, PivotChart and Power
View Report and Microsoft Excel Access:
Author: Toraj
Khavari
Date: September
20, 2016
Objective: Describe how to access SQL
Server Analysis Services (SAS) to use PivotTable, PivotChart and Power View
Report in Microsoft Excel.
Article Body: Often you may find
yourself among people talking about using Microsoft Excel PivotTable,
PivotChart and Power View Report while connecting to the corporation SQL data
base. You ask yourself how that is possible. The following are the instructions to access SQL SAS using Microsoft Excel.
1-
In Excel, select Data Tab, From Other Sources
and From Analysis Services.
2-
Type server name (ask your data
base administrator), check the User Windows Authentication, next
3-
Select the SQL Cube, in my case it is EDW,
press next.
4-
Select Finish.
The user will perform the above tasks,
once. Thereafter, the excel user can use Data Tab, Existing Connection, Open.
5-
Select the desired feature or default
PivotTable.
6-
The user is in EDW. You are done.
Enjoy using Microsoft Excel, PivotTable, PivotChart and
Power View Report. They are powerful way of looking at and creating reports.
Cheers, Toraj
