Thursday 4 August 2016

Expose Attribute Views as XS OData Service in HANA

1. You need to change the Eclipse IDE perspective to SAP HANA Development. Navigate to Window → Open Perspective → Other to change the perspective of your HANA Studio to SAP HANA Development   (OR)   Select the SAP HANA Development perspective in the perspective shortcut which is at the top right corner of your SAP HANA Studio.

Expose Attribute Views as XS OData Service in HANA

2. In the Open Perspective window, select SAP HANA Development Perspective and hit OK.

Expose Attribute Views as XS OData Service in HANA

3. In the left section, you will see three new tabs Project Explorer, Repositories and Systems.Select Repositories tab.

4. Right click to create a new repository workspace for the HANA System you have already logged in.

Expose Attribute Views as XS OData Service in HANA

5. In the Create New Repository Workspace window, select the HANA system for which you want to create workspace, enter Workspace name and hit Finish.

Expose Attribute Views as XS OData Service in HANA

6. Your new workspace will be created

Expose Attribute Views as XS OData Service in HANA

7. Expand the created workspace and identify your repository package , right click on it and choose Check Out.

Tip : Checked out package will have tick mark like thisCheck_Out

Expose Attribute Views as XS OData Service in HANA

8. After checking out, select your package and press Cntrl+N (or) Right click → New → Other.

9. In the New window search with XS OData and select XS OData FileXS_OData_File  
and hit Next.

Expose Attribute Views as XS OData Service in HANA

10. In the New XS OData Service window, enter File name, choose Template as “Basic” and hit Finish.

Expose Attribute Views as XS OData Service in HANA

11. A new HANA XS OData service will be created with predefined syntax like below.

Expose Attribute Views as XS OData Service in HANA

12. We are not going to use the predefined syntax as it, remove that and copy and paste the below code

Expose Attribute Views as XS OData Service in HANA

13. Lets see what the HANA XS OData service file contains
  1. Service definition starts with syntax – service {  }.
  2. you have to provide the full path of attribute view where it is stored and its name.
  3. as  –  you have to provide the Entity Type name.
  4. with – columns of attribute view you want to expose.
  5. key – key of the attribute view.

14. Activate the service by clicking on Active Button Activateon the tool bar.  You can also right click on the package and choose Activate / Activate All.

Expose Attribute Views as XS OData Service in HANA

15. Before testing the service we need to first expose our package to do so we need to create two files in our package they are .xsaccess and .xsapp. Right click on your package → New → File

Expose Attribute Views as XS OData Service in HANA

16. Copy and paste below code into newly created .xsaccess file.

Expose Attribute Views as XS OData Service in HANA

17. Again repeat the Step-17 to create .xsapp file. This file will be a blank file.

18. Activate all objects in the package. Now we are ready for testing.HANA XS OData services are accessed by URL.Open your chrome browser and enter URL of your XS OData service in the below format.

http://hostname:port/package/file.xsodata

18. You will see the XS OData service metadata output like below in the browser.

Expose Attribute Views as XS OData Service in HANA

19. Now append the entity name “EmployeeCollection” to the above URL and you will see the data of the attribute view like below.

Expose Attribute Views as XS OData Service in HANA

20. We you have successfully exposed HANA attribute view as XS OData service.Now we can use this XS OData service in SAPUI5/SAP Fiori applications to display the data in UI.

Source: scn.sap.com

No comments:

Post a Comment