Skip to Content
Author's profile photo Former Member
Former Member
August 15, 2012 1 minute read

Connecting to Excel with HANA

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.