BI 4 on HANA-Part 6: Setting up HANA as an application server for Design Studio
In the previous post (BI 4 on HANA-Part 5: Setting up HANA as a datasource for Design Studio and Analysis Office) you have seen how to enable the the HTTP connectivity on HANA so that Analysis Office and Design Studio can access data there.
With this setup you can access HANA using the Design Studio and Analysis Office local mode by defining a local connection.
In Design Studio you also have the option to use HANA as a platform where you can save and execute your applications. Using this configuration you minimize the data movement.
In order to enable HANA as a platform for Design Studio you have to first enable the HTTP connection, as described in the previous post and then install and deploy (on HANA) the Design Studio addon for SAP HANA.
Let's see how you can do it.
To follow the steps below you need a running HANA instance and a HANA Studio connected to it.
FYI, the information presented here is availble in various Help guides and posts on the SCN, in this blog post we are just trying to put it togehter in a single place and show a detailed, step by step, workflow. But this article does not substitute the official documentation, if something is wrong, the place to go is the official help guide.
Installing and deploying the HANA addon
As a first step you need to obtain (e.g. by downloading it from the Software Downloads | SAP Support Portal site) the Design Studio for HANA application (usually labeled DESIGN_STUDIO_HANA_XX where XX is the version number).
You save the zipped file on the local machine where you have HANA Studio and then unzip it.
You launch HANA Studio and select File/Import/Delivery Unit and select the HANA machine onto which you want to install the add on (the same steps you performed in the previous section).
In the Import Throught Delivery Unit window you select the Client option and click browse
You navigate to the folders where you unzipped the addon and select the HCOBIAAS.tgz file
Notice that this file might appear within a zipped file inside another zipped file (as in the picture above).
Click the OPEN button. HANA Studio now takes a few seconds to simulate the import of the unit.
When you have back the control, make sure the Overwrite and Activate checkbox are selected and click Finish.
The addon is now up and running in your HANA instance. Congratulations !
Configuring access and privileges on HANA
At this stage HANA users with the INA_USER right (described in the previous blog BI 4 on HANA-Part 5: Setting up HANA as a datasource for Design Studio and Analysis Office ) can access applications created with Design Studio which are built on HANA views they have the right to see. Make sure you completed the steps in the previous post before continuing here.
To build new Design Studio applications you need to provide additional rights to the designers.
You can create, as an example, a new role called DS_DESIGNER (follow the same workflow shown in the previous blog to create a new role).
In this new role you have to provide the following rights:
- In the Granted Roles add the INA_USER
- You now go to the Package Privileges tab and add the designstudio package. Notice that the UI for selecting the packages might be slow, depending on the quantity of packages in your HANA system. You should specify designstudio in the searchbox and then click in the Matching Items box and wait a few seconds to get the results.
- Once you added the designstudio package you assign the following rights:
- In the Object Privileges add the Execute, Select, Insert, Update and Delete right to both _SYS_BI and _SYS_BIC catalogs
You now deploy the role by hitting the green arrow at the top right of the screen.
Finally you assign this role to a user who you want to make designer of Design Studio applications.
When you deploy the change to the user this person will be able to run Design Studio in HANA mode and create new applications.
You are done!
You have learned in this article how to setup HANA so that it can host and execute applications created with Design Studio.
In the future article about Design Studio you will learn how to connect to the HANA platform and how to run the applications on it.
I hope this article was useful!
You can go back to the list of available articles here: SAP BusinessObjects BI 4 on SAP HANA