Wednesday 7 January 2015

Connecting cube to excel step by step

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


10 comments:

  1. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.
    MSBI Training in Chennai

    ReplyDelete
  2. Great Info, Thanks For Sharing , keep it up we are here to learn more

    Great! I like to share it with all my friends and hope they will also like this information.
    ADF Training In Hyderabad
    ADF Online Training
    ADF Training
    ADF Training Online S

    ReplyDelete
  3. Great Info, Thanks For Sharing , keep it up we are here to learn more

    Great! I like to share it with all my friends and hope they will also like this information.
    ADF Training In Hyderabad
    ADF Online Training
    ADF Training
    ADF Training Online S

    ReplyDelete

  4. Microsoft Business Intelligence is known as MSBI. This rich collection of technologies enables the finest responses to Business Intelligence and Data Mining Queries. An SQL server and Visual Studio are both used by this programme. It allows users to obtain accurate and current information for better organisational decision-making. It provides various tools for the many tasks that Business Intelligence (BI) solutions call for. To learn more about MSBI tools, join MSBI Course in Chennai at FITA Academy.
    MSBI Training in Chennai

    ReplyDelete

If you have any doubt, please let me know.

Popular Posts