Skip to Content

I’m currently working on a project that uses Design Studio 1.2 on top of SAP HANA. As in most projects a customer doesn’t always have a HANA server for each environment like DEV, TST, Q&A, etc. This means that when using HANA views in Design Studio these Views are in different ‘packages’. So in order to switch your Design Studio application from the Views in the ‘DEV’ package to the ‘TST’ package you need to go into the Design Studio client application and change the data source.

/wp-content/uploads/2014/02/screen01_389893.png

However this can be very cumbersome if you have invested a lot of time in setting up the correct initial view for each data source. After all changes the data source inside Design Studio resets the initial view. In my project we have over 10 HANA views so even that is what you want to be doing ;-).

I have been experimenting to check whether there is a different way of doing this. Design Studio allows you to save an application you have created locally (in this example the application is stored on the BI 4.1 platform). If you go to

/wp-content/uploads/2014/02/screen02_389909.png

You need to browse to a folder where the application will be saved. When you go to this folder you can see that Design Studio created a folder which contains 2 files.

/wp-content/uploads/2014/02/screen03_389911.png

The metadata.properties file contains simply contains some metadata 😉 but the interesting file is the content.biapp file. When you open this file with for instance notepad it contains the complete coding of your application.

All we need to do now is to find the area which contains the reference to the data sources used. Use a simple CTRL+F and search for ‘DATA_SOURCE_NAME’.

/wp-content/uploads/2014/02/screen04_389913.png

You can change the value to match to correct package and save your changes!

Next step is to open the application via Design Studio. Click on Tools – Upload Local Application.

/wp-content/uploads/2014/02/screen05_389914.png

Browse to the .biapp file and select the folder where you want to save the application on the BI platform. You can also rename the file and change the description.

Please make sure that you properly test whether this will actually work in your specific situation as this is probably unsupported ;-).

If you have any comments or questions please let me know!

With kind regards,

Martijn van Foeken | Intenzz

To report this post you need to login first.

7 Comments

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

  1. Leandro Cardoso

    Great… Tried this with a Bex Query source, didn’t quite work because the two querys are not identical, and I don’t have two identicals to test.

    But it should work too.

    (0) 
    1. M. van Foeken Post author

      Hi Leandro,

      I guess it should work indeed. Please let me know once you have had time to validate this!

      With kind regards,

      Martijn van Foeken | Intenzz

      (0) 
        1. M. van Foeken Post author

          Hi Leandro,

          Thanks for the feedback on the document. Great to hear that it works even changing the OLAP connection.

          Probably a lot of other settings and references can be changed as well.

          With kind regards,

          Martijn van Foeken | Intenzz

          (0) 
  2. Tammy Powlas

    Hello Martijn,

    I am behind on commenting and reading but thank you for once again sharing your knowledge on Design Studio.


    This is something to check out…thank you again for the tip.

    Tammy

    (0) 
    1. M. van Foeken Post author

      Hi Tammy,

      Thanks for your comment! I’m way behind myself with reading so no hard feelings 😉 . Hope I can share some additional knowledge on this topic in the near future.

      With kind regards,

      Martijn van Foeken | Intenzz

      (0) 

Leave a Reply