Accessing SSAS Cube Via. Excel

• Open Microsoft Office Excel.
• Go To Data Tab. 

• Select “From Other Sources” 
• Now, Select “From Analysis Services” Specify “Server Name” & “Credentials”. 

• Now, Just Drag and Drop fields in “Row Labels”, “Column Labels” and Values sections to create report.