Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Create your own application site using SAP HANA UI Toolkit

It’s easier now to start creating your own site using the HANA UI toolkit since HANA SP7 release, embedded with sample data, and service kit as being part of the HANA Installer.

In this blog I would like introduce the changes in regard to import of Delivery Units and few other steps that are changed as part of HANA SP7 release

Thanks to Lucas for briefing out the introduction to SAP HANA UI Toolkit for Information Access (earlier) in his blog.

I would like to provide further information’s regarding the latest changes until HANA SP7 release

Prerequisite: HANA appliance software is installed on your server.

Necessary role/User for the system access

  • access to the OS level via console, using the <sid>adm user of your HANA
  • access to the DB of your HANA via DB user

Install the UI Toolkit

Download Delivery Unit

Download the Delivery Unit from SMP (service market place):  https://websmp103.sap-ag.de/support

Note: Since SP6 onwards , the UI toolkit is available as part of SMP (SAP Service market place) . The service delivery Unit (HCO_INA_SERVICE.tgz) is part of the HANA installer.

Path to view the service DU within HANA installer: SYS/global/hdb/content

Import Delivery Unit:

Launch HANA Studio  

Select your HANA instance

On the Quick launch page, choose Content -> Import

Now Select HANA Content -> Delivery unit.

Choose Next

Select the server, browse the Service DU (Service DU on server: SYS/global/hdb/content): HCO_INA_SERVICE.tgz

Similarly select the client, browse the UI tool kit DU (downloaded from SMP to your client) : HCO_INA_UITOOLKIT.tgz

SP6: Sample data (EPM: Enterprise Procurement model) is part of <SYSTEM> schema 

SP7: EPM Table content can be found in <INA_EPM_DEMO >schema and EPM Column views can be found in “SYS_BIC “schema 

In the SAP HANA modeller, in the SAP HANA Systems view, under Content, check that the following packages

are available:

sap\bc\ina\demos

sap\bc\ina\uitoolkit

sap\bc\ina\api

sap\bc\ina\uicontrols

INA role and authorizations to HANA users since SP7

The sap.bc.ina.service.v2.userRole:: INA_USER role grants access to the info access HTTP service and enables the processing of metadata retrievals.

The above role can be assigned to a user in different ways. Role can either directly assigned to the user OR reference it in another role

System user:

Role required: sap.bc.ina.service.v2.userRole::INA_USER

Self-defined user

Role: sap.bc.ina.service.v2.userRole::INA_USER

For non-system user assign the INA role.

Assign the select privilege on the attribute view and the underlying tables.

Assign select and execute privileges on _SYS_BIC schema.

Add the Analytical privilege “_SYS_BI_CP_ALL” to the user if it is not present.


Prepare your Source Data.

Enabling Search Options in HANA Studio and Register and Activating the Service are no more relevant .It’s available by default

User should have a knowledge of what attributes he wants to enable for free style search , which records he wants to enable for users , what attributes he wants to see a count of distinct values or add filter .

Go ahead and create Attribute view via studio

Select an attribute in your model and observe that there is tab to enable search attributes.

Define freestyle attributes,( apply full text indexes and set up text analysis if required else as a first step just try the enable one or two attribute as freestyle search )

(For more details , please refer section 9.4,   http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf)

Set Up Dev environment:

Before you create your own site, it is required to set up Dev environment .With the help of regi , one can modify the Hana repository files.

  1.   Ensure SAP HANA™ Client is installed on your machine.
  2.   Create local Workspace:

   - Open Command prompt and run the following commands:

                        Hdbuserstore set <key name> <host name>:3<sys no>15 <USERNAME> <PWD>

Regi create workspace <workspace name>  --key=<key name>Change your directory to the newly created local workspace directory.

Regi track sap.bc.ina.demos 

(to map ‘sap.bc.ina.demos’ repository package to your workspace)

Regi checkout

                 (Writes all the repository objects to your local workspace)

   3.     Develop your own html pages and Save them.

             (You can also create a copy of any of the existing UIs and edit.   

   4.     Commit the changes back to HANA repository.

Regi commit

  (You should be able to see your UI inside ‘sap>bc>ina>demos’ now)

    5.     Activate all changes in your UI.

  Regi activate

     6.     For more information on Regi, refer to the following wiki link:

http://trexweb.wdf.sap.corp:1080/wiki/index.php/Regi


Creating your own site:

Please refer to the previous blog 

lucas.sparvieri/blog/2012/08/13/how-to-create-your-own-web-application-using-sap-hana-ui-toolkit-for...

Launch the URL:

http://<HANAhost>:80<instance>/sap/bc/ina/demos/myapp/search.html

Thanks ,

Reena S

10 Comments
Labels in this area