How to Pull Data from a Cube to EXCEL Sheet?

The first thing that we have to do is open an excel sheet and click on the same link as shown below in the diagram to connect it through some analysis service.

After this you need to provide the credentials of the server whichever you want to connect to. And then you will be connected to the analysis service, where you have to select the required cube to get the desired data.

The shaded (blue) part is the name of the  cube which we have to select from the specified server. After selecting press on NEXT button.

 Then you can click on FINISH button to get the screen as shown below.

After this you can pull the data accordingly using the hierarchy provided on the right side of the excel sheet(above).

Rest of the things depend on the business requirement.