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.

DSBlog_1.png

After unzipping the file use the SAPCAR utility to ‘unzip’ the HCOBIAAS00_0.SAR file.

DSBlog_3.png

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’.

DSBlog_2.png

Click ‘Next’. Select the Target System and click ‘Next’.

Select ‘Client’ and browse to the HCOBIAAS.tgz file.

DSBlog_4.png

Click on ‘Finish’. Validate in the ‘Job Log’ whether the Import is Completed successfully.

DSBlog_5.png

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.

DSBlog_6.png

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’.

DSBlog_7.png

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>.

DSBlog_8.png

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.

DSBlog_9.png

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.

DSBlog_10.png

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.

DSBlog_11.png

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.

DSBlog_14.png

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’.

DSBlog_12.png

After being prompted for your SAP HANA credentials the analysis application is presented!

DSBlog_13.png

DSBlog_15.png

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

To report this post you need to login first.

25 Comments

You must be Logged on to comment or reply to a post.

    1. M. van Foeken Post author

      Hi Kumar,

      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.

      Did you assigned this role to the user on SAP HANA?

      With kind regards,

      Martijn

      (0) 
  1. Mike Houston

    Hi M Van Foeken,

    Thanks for sharing I enjoyed reading your post. Btw, how do we deploy DS apps on HANA to a mobile device. I am aware that when DS is deployed using the BIP addon we can simply categorize it under the mobile category and consume the app using the SAP BI mobile app, however I can’t find any information on how to consume the DS app on a mobile device when using HANA. Any info will be greatly appreciated! Thanks.

    – Mike

    (0) 
    1. M. van Foeken Post author

      Hi Mike,

      The easiest way is to go to ‘Application’ – ‘Execute on SAP HANA’. Copy the URL to your mobile device and open it in the browser. You will be prompted to provide the username and password on SAP HANA and the application will render. That’s the benefit of HTML5 ;-).

      foto1.PNG

      foto2.PNG

      With kind regards,

      Martijn

      (0) 
      1. Mike Houston

        Thanks for your reply M Van Foeken,

        So basically when accessing a DS app deployed on native HANA there is no way of accessing it through the SAP BI mobile app? Based on your reply, what I understand is that the only way of accessing it on a mobile device (such as iPad) is to copy the URL and paste it in a browser (such as Safari)? Correct me if I am wrong here.

        Many thanks!

        Mike

        (0) 
        1. M. van Foeken Post author

          Hi Mike,

          As per my understanding that is correct. The Mobile BI app can only display content which is stored on the BI platform and not natively on SAP HANA.

          With kind regards,

          Martijn

          (0) 
  2. Justin Molenaur

    Martijn, first off thanks for the blog, very cool direction DS is heading.

    One glaring question that popped up in my head is how this is positioned from an end user consumption perspective. For example, how does a given user actually navigate to the DS apps other than a direct URL? And furthermore, how do apps or groups of apps get assigned to users for consumption?

    My comparison here is the deployment options in BOE, where uses have the Launchpad/document browser concept and the apps can also be subject to security by folders/objects.

    Regards,

    Justin

    (0) 
    1. M. van Foeken Post author

      Hi Justin,

      Great you liked the blog! The positioning of DS running directly on HANA is for those customers that have not (yet) invested in the BOE platform. The consumption for end-users can be simplified by building for instance a small XS application or simple HTML page.

      Apps and / or group of apps can be assigned by granting access to different packages. Each app is stored in a different sub-package.

      With kind regards,

      Martijn

      (0) 
    1. M. van Foeken Post author

      Hi Weicheng,

      I’m not sure if I understand your question correctly. What do you exactly mean with ‘change the system when I assign on system already’?

      With kind regards,

      Martijn

      (0) 
    1. M. van Foeken Post author

      Hi Kyle,

      I don’t have any experience with the possibilities and the degrees of freedom an AWS HANA instance offers compared to an on-premise system. As long as you are able to follow the steps on the AWS instance you might be able to do it. Please let me know once you have tried it, ok?

      With kind regards,

      Martijn van Foeken

      (0) 
  3. Konstantin Shapoval

    Hi Martijn,

    According to note 1993123 – Design Studio Release 1.3: HANA deployment restrictions: Variables and Input Parameters are not supported. Is there a way to parameterize a report?

    Best regards,

    Konstantin

    (0) 
    1. M. van Foeken Post author

      Hi Konstantin,

      I expect that in the near future Variables and Input Parameters will be supported when deploying Design Studio on HANA. Don’t have a clear answer on workarounds at the moment. Depends on your application.

      With kind regards,

      Martijn

      (0) 
  4. Kyle Swanson

    Hi Martijn,

    Just as a follow up, I have successfully connected my Design Studio 1.3 to HANA AWS SP 08 using the steps above.  I can execute from the HANA Platform Directly but I run into an issue that I’m hoping someone in the community has experienced.

    When I execute on the HANA Platform, my CSS renders in the browser but none of the KPI’s (which I can see in my Studio) load.  When publishing in Local Mode, I can see all my KPI’s but none of the CSS.

    I am thinking that there are configurations I need to make either in my  AWS account (i.e. specific port or security parameters) to get this to render appropriately.  Any thoughts or comments would be appreciated!

    Thanks,

    Kyle

    (0) 
  5. Antony Jerald J

    Hello M. van Foeken,

    Thanks for sharing.

    I’ve one query in my mind after going through the document.

    When using SAP Hana as a preferred mode, how does users have login access to design studio dashboard ?

    While using BI Platform as preferred mode, we can give access to users based on folder level access from BI platform,..How does dashboard designed using hana as preferred mode can be made available to users?

    Kindly suggest.

    Regards,

    Antony Jerald.

    (0) 

Leave a Reply