Thursday, December 15, 2016

Analysis Office/Excel /

Excel to HANA:

Connect to SAP HANA using the MDX language

In order to make MDX connections to SAP HANA, the SAP HANA Client software is needed. This is separate to the Studio, and must be installed on the client system. 


-we can create report quickly by pivot tables and charts.
-MS Office uses MDX language ((Multi Dimension Expression language) to access data from SAP HANA.
-can access only SAP HANA information view which has a property as 'CUBE' in semantic, so we cannot access attribute view by MS Excel.
-ODBO: OLE DB FOR OLAP


1) MS Excel -> From other sources -> Data Connection Wizard
          A)Other/Advance   B) Data link properties i) SAP HANA MDX provider \
           C)data link properties i) host name of DB ii)instance number iii)UN/PW iv) enter language name v)test connection

Step 1) Connect To SAP HANA Excel-

  1. Open MS Excel. Go to Data Tab.
  2. Click on "From Other Sources" Icon.
  3. Select From Data Connection Wizard.
A screen for Data connection wizard will be displayed as below-
  1. Select "Other / Advance" option.
  2. Click on Next Button.
A window for "Data Link Properties "will be open as below-
  1. Select "SAP HANA MDX Provider "under Provide Tab.
  2. Click on Next Button.
A window for data link properties will be displayed –
Enter the following detail as below –
  1. Enter Host Name of SAP HANA Database.
  2. Enter Instance number of SAP HANA database.
  3. Enter Username / password for SAP HANA database.
  4. Enter Language name.
  5. Click on "Test Connection" to test the connection to SAP HANA Database from Excel.



Step 2) Till now we had created a connection from EXCEL to SAP HANA and tested the connection. Now we access SAP HANA Information View from Excel.

Now a window for "Data connection wizard" will be displayed.
  1. Select the package in which contains SAP HANA Information View.
  2. Select Information View (Analytic View, Calculation View).
  3. Click on Next Button.
A new window for data connection File will appear, enter following details.
1. Give File Name (AV_SALES).
2. Tick option "Save password in file", for avoid to enter a password while open excel file.
3. A Pop-up for save password security related will be displayed.
4. Click on Finish Button.

Step 3) Now SAP HANA Information View will be displayed in Excel as pivot table as below 

Questions(EXCEL):
1) MS Excel -> From other sources -> Data Connection Wizard
          A)Other/Advance   B) Data link properties i) SAP HANA MDX provider \
           C)data link properties i) host name of DB ii)instance number iii)UN/PW iv) enter language name v)test connection
2)Data Connection Wizard
        A) i)Choose pkg with HANA information view  ii) Select information view
        b)Data Connection file  i) file name ii) save pw  
A)  What sources from the data connection wizard comes next?
    Data link ===>  MDX provider  ==>  Data Link properties (host name, instance number, UN/PW), Enter language name,  test connection
  B) Data connection Wizard 
     Package with HANA information view ==> information view ==>  data connection file (file name, save pw)

What client tools have access to HANA directly?  Excel, SAP BI, Reporting tools, Dashboard, Design tool(Xcelsius) 

What is the BO analysis edition for Microsoft office?
             -Multidimensional data analysis with Microsoft office user experience
vs.
What is the BO Analysis, edition for OLAP?
                   - Multidimensional data analysis within a web-based environment
-ODBO: OLE DB FOR OLAP

End Users Workstations :
i.   MS Excel 2010
ii.   SAP HANA Database Clients 1.0
     iii.   Web Access to BI Clients (1577128)

 What constitute SAP BO Analysis (BICS)?
a.     MS Excel 2010
b.    MS Powerpoint 2010


        To which components are Hierarchies available in SAP HANA ?
          Hierarchies only available Excel and ODBO.



----------------------------------------------------------------------------------------------------------------------------------------------------

Webi












Excel:
http://saphanatutorial.com/connect-sap-hana-from-excel/

http://dba1admin.blogspot.com/2015/12/sap-hana-questions-and-answers.html

No comments:

Post a Comment