Open the excel file
Click on the data section and select from other source. You will
get different data source. Select From Analysis service.
Click on that
Write the server Name and select the windows Authentication.
Click on next button.
Select the cube which one you want export in excel.
Click next
Click Finish
Click ok.
You will get the pivot Excel
You will get the desirer reports
