Skip to Content

Using Excel to Display HANA Data (Microsoft Excel 2010)

    1.PNG

  
    Data –> From Other Sources –> From Data ConnectionWizard –>

2.PNG

Other/Advanced –> Next

   3.PNG

SAP Hana MDX Provider –> Next

4.PNG

Enter Credentials to log into HANA

  5.PNG

    6.PNG

7.PNG

Test Connection to ensure that the connection is working.

 
8.PNG

Select the Database Table that you want to analyse.

  

9.PNG

  Drag and Drop the Characteristics and Key Figures into the Rows and Columns.

http://www.fm-consulting.co.uk

shabar@fm-consulting.co.uk

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply