SAP Design Studio on SAP HANA: Integration with Fiori Launchpad

[poovin2749]

SAP Design Studio – the most versatile analysis tool from SAP – can be hosted on all three platforms offered by SAP (SAP BusinessObjects, SAP Netweaver and SAP HANA). However, the application performance and supported features are not the same across the three. Although SAP Design Studio on SAP HANA offers better performance than the other two platforms, it does not support some really important features like a launchpad and mobile compatibility. This makes it difficult for developers, admins and the end users as well.

SAP Design Studio on the SAP HANA platform might lack some of the features available in SAP BOBJ or SAP Netweaver, but it is designed to integrate well with SAP HANA’s application server and security models. This provides us with options to enhance the Design Studio implementation on top of SAP HANA.

An important feature that end users need, is a launchpad to organize content. Design Studio applications can be integrated into SAP HANA’s Fiori Launchpad and they will use the authentication and authorizations defined within the SAP HANA system.

Prerequisites

We will need the following components to make use of this feature

1. SAP HANA 1.0 SPS08 (or) above
2. SAP Design Studio 1.3 (or) above
3. SAP Lumira Server 1.20 (or) above (SAP Lumira Server provides the Fiori Launchpad)

When Lumira Server is installed on top of SAP HANA, it provides two Launchpads

1. SAP HANA BI Launchpad (http://hostname:port/sap/bi/launchpad)
2. SAP HANA Fiori Launchpad (http://hostname:port/sap/bi/launchpad/fiori)

Now let us explore the steps to integrate SAP Design Studio with the Fiori Launchpad.

Step by Step Procedure

Step 1:

Launch HANA Studio and login as a user who has edit/activate rights on the ‘sap.bi.launchpad.fiori’ package. After logon, switch to ‘SAP HANA Development’ perspective.

Step 2:

Select the ‘Repositories’ view.

Step 3:

Select the ‘launchpad’ sub-package, located under ‘sap.bi’ package in the Repository.

Step 4:

Right click on the ‘launchpad’ package and select ‘Check Out and Import Projects’ option.

Step 5:

The next screen will show the repository package that is to be imported and the local path where the file is stored.  Click on ‘Next’.

Step 6:

Select the ‘fioricontent’ project from the project list and click on ‘Finish’ to import the project to workspace.

Step 7:

Now select the ‘Projects’ view. The files imported from the server will be available in the project workspace.

Step 8:

Now we need to create an ‘XSWIDGET’. To create a widget, right click on the project and select ‘New -> Other ‘.

Step 9:

Select the ‘UIS Catalog’ and click on ‘Next’. ‘UIS Catalog’ is located under ‘SAP HANA -> Application Development’.

Step 10:

Enter the file name and the catalog name and click on ‘Finish’ to create a template widget. Check the ‘Generate Privilege’ option to generate ‘Application Privileges’.

Step 11:

Now the ‘DesignStudio_EPM’ widget will be created. Open the file by ‘double-clicking’ on it.

Step 12:

Now click on the ‘+’ sign located in the middle of the empty widget and it will give you the list of launchers available. Select the ‘Static App Launcher’.

Launcher Selection Menu

After Launcher Selection

Step 13:

Now click on the ‘Static App Launcher’ and fill in the details as shown below

General Information

Navigation

Uncheck the ‘Semantic Object Navigation’ checkbox. We will be using static application URL.

Target URL

Enter the application’s URL and click on ‘Save’, to complete the widget configuration. The widget can identify the application, even if a relative url is given here.

Step 14:

Now right click on the modified files and select ‘Team -> Commit’, followed by ‘Team -> Activate’.

Step 15:

Now login to the Fiori Launchpad, using your SAP HANA system credentials. The URL format is http://hostname:port/sap/bi/launchpad/fiori

Click the ‘Show/Hide Group Panel’ icon

Select the ‘Tile Catalog’ option at the bottom of the ‘Group Panel’.

Among the available tiles, search for the ‘Design Studio’ catalog and ‘EPM’ application tile that was created in the previous steps.

Step 16:

Now select the ‘+’ sign located at the bottom of the tile and create a new group with name ‘Design Studio’ and click on ‘OK’ to add the tile to the group.

Step 17:

Now the tile is available in your Home Screen under the group ‘Design Studio’.

On clicking the tile, it will launch the SAP Design Studio application mentioned in the Target URL. Since the Fiori Launchpad and the SAP Design Studio application are hosted on the same SAP HANA server, the authentication and authorizations defined at the backend are applicable to SAP Design Studio as well. This Launchpad will help users with an organized access to all their reports and dashboards from one place.

It is important to note that this is a ‘How-To’ on integrating SAP Design Studio applications with the Fiori Launchpad and is different from the ‘Design Studio – Fiori’ integration feature of SAP Design Studio 1.4.

Follow this blog series for more information on security, application privileges and advanced launcher options.

Keep Exploring !

source : http://visualbi.com/blogs/design-studio/sap-design-studio-sap-hana-integration-fiori-launchpad/

[Former Member]

Excellent post Poovin! Congrats!!

[poovin2749]

Thanks Enio.

[Former Member]

Thanks for sharing.

Very informative topic and useful one.

Adding here :

To make visible this report to other users follow below steps:

Open HANA user ->select Application Privileges tab ->add "sap.bi.launchpad.fioricontent::WidgetAccessDesignStudio_EPM"

So other user can able to access this report after granting the above privilege.

[Former Member]

Thank you for sharing this information. But I'm a little bit confused due to the many options to create a Launchpad and integrate services. I’m looking for a central Launchpad that includes several information. My last information is that an ABAP Sap Netweaver Gateway is the best solution to start together with ERP. But now I would like to include reports from Solution Designer on data warehouse. Of course we would be also open for HANA reports later on. Can somebody help me here?

[poovin2749]

Hi Simon,

ABAP Netweaver gateway is the best way to start to complete this requirement. Since you want this Launchpad to point to different systems, it may not be possible to manage all the content in a central system, but have their references in the single Launchpad.

Ideally you can have a single central Launchpad pointing to applications in different systems. You will also need lot of configurations to be done for SSO between systems to avoid users from being challenged for credentials.

Else the next feasible solution is to create a custom SharePoint / HTML portal and place references of each application in that portal. This will also need configs for SSO.

Thanks,

Poovin.

[RodrigoCaparroz]

Awesome Great! :cool:

[Former Member]

Is it also possible to integrate a Design Studio report based on BI platform into Fiori (e.g. via opendoc url)?

Thanks

[poovin2749]

Hi Robert,

Yes, you can embed open-doc url on Fiori tile, however that would act only as a launcher. It will redirect you to the BI Launchpad, as soon as you launch it.

Single sign on will not take place out of the box and that will need several configurations.

Thanks,

Poovin

[Former Member]

Hi Poovin,

thank you for your answer.

Do you have any documentation on integrating an open-doc on a Fiori-tile?

Thank you.

[nmsr1976]

Hi Poovin,

Where can we find more information of Fiori em BI Platform?

Thanks in advance,

Narciso

[MPS4HANA]

Hi Poovin,

Thanks for detailed doc.

Few basic questions --

In S/4HANA 1511 FIORI Launchpad - thru "Query Browser" when I try to open the Query via "embedded??"  DesignStudio - it opens Designstudio giving two errors -->

(1) Could not instantiate the data source for query DS_1.

(2) Service Unavailable

While few blogs/posts mention removing Language in OLAP connector, can you help understand the reason of this issue and how to resolve it.

Is there some setting required for this to work ?

Anticipating your response, thanks,

Best Regards,

MP

[Cas12]

good afternoon expert

hi Poovin  Kumar

I can work with information concerning:

1. How to activate or install fiori to work sap BO 4.2

2. How to activate or install Fiori to work with BW 7.4

I appreciate the collaboration

yimi Castro