With the release of SAP BusinessObjects Design Studio 1.3 it’s now possible to use SAP HANA as the platform for Design Studio. SAP HANA is used as repository to store analysis applications and images, and also as a back-end system, providing the business data for data analysis in analysis applications. There is a current limitations however: you can only connect to one SAP HANA system and you can only add data sources to your analysis applications from one SAP HANA system.
In this blog I will show you how easy it is to install and run Design Studio directly on SAP HANA.
The prerequisites to use SAP HANA as the platform for Design Studio are listed below (these can be found in Administration’s Guide):
- SAP HANA SPS 08 is correctly installed. For more information, see SAP Note 1993123
- SAPUI5_1 Delivery Unit is installed on the SAP HANA system.
- HCO_INA_SERVICE Delivery Unit is installed on the SAP HANA system.
- A suitable version of SAP HANA Studio is installed on the local machines of your application designers.
After downloading the DS HANA 1.3 installation package from the location below unzip the file.
After unzipping the file use the SAPCAR utility to ‘unzip’ the HCOBIAAS00_0.SAR file.
Next step is to install Design Studio in SAP HANA Studio. Start the SAP HANA Studio and choose ‘File’ – ‘Import’ – ‘SAP HANA Content’ – ‘Delivery Unit’.
Click ‘Next’. Select the Target System and click ‘Next’.
Select ‘Client’ and browse to the HCOBIAAS.tgz file.
Click on ‘Finish’. Validate in the ‘Job Log’ whether the Import is Completed successfully.
By importing the Delivery Unit successfully the packages designstudio and designstudio_extensions are created in SAP HANA Studio. Analysis applications and images used in the applications are stored in the designstudio package. SDK extensions deployed to SAP HANA are stored in the designstudio_extensions package.
The final step is to validate whether we are actually able to store analysis applications on SAP HANA and use it as the platform to run the applications. Start the SAP BusinessObjects Design Studio 1.3 client.
Go to ‘Tools’ – ‘Preferences’ and change the ‘Preferred Startup Mode’ to ‘SAP HANA’. Click on ‘OK’. The Design Studio client will prompt you to restart the application so changes will become affective. Click on ‘Restart’.
During the restart of the Design Studio client you will be prompted with your SAP HANA credentials and the URL of your SAP HANA XS Engine. After submitting the information please click ‘OK’. Your XS Engine URL would be like: http://<server><port>.
After you succesfully logged in you can see you are connected in the bottom right of your screen. Click on the SAP HANA System name and view the properties of your system.
Now let’s create a new application. Click on ‘Application’ – ‘New’.
Hint: Make sure that before you create any new application your SAP HANA user has sufficient priviliges on the 2 packages created during the ‘Import’. If your user has the standard ‘Modeling’ role this should be sufficient. You can fine tune the authorizations on these packages later.
Click ‘Next’ if you want to select a template. For now just click ‘Finish’. In the bottom right corner a ‘Message from Backend’ will appear. In this case we successfully created the ‘HANA_TEST’ application.
To ensure that a user on SAP HANA can Execute an analysis application on SAP HANA you need to assign the sap.bc.ina.service.v2.userRole::INA_USER role to the user executing the application.
I created a very simple application with 1 crosstab containing 10 rows of data from an Analytic View. Now let’s Save the application and go to ‘Application’ – ‘Execute on SAP HANA’.
After being prompted for your SAP HANA credentials the analysis application is presented!
I will run some further tests next week to validate the functionality!
Please let me know if you have any questions!
With kind regards,
Martijn van Foeken