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.
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
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
Role required: 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.
- Ensure SAP HANA™ Client is installed on your machine.
- 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)
(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.
(You should be able to see your UI inside ‘sap>bc>ina>demos’ now)
5. Activate all changes in your UI.
6. For more information on Regi, refer to the following wiki link:
Creating your own site:
Please refer to the previous blog
Launch the URL: