Skip to Content

Hello All,

SAP has been marketing Role based Fiori applications very extensively.

These days, customers want most of their application types to be configured in Fiori Tiles and its a fact that the look and feel of Fiori app is simply “BINDAAS”, when compared to our old legacy screens.

Last week I was asked by customer to configure a BW BEx Report in a Custom Fiori Tile.

As Fiori is relatively a new topic, I would be covering a very detailed step by step process here to demonstrate the configuration and will ensure to include as much as screen shots possible from my end.

So here we go,

A small introduction to Fiori:

Fiori is a collection of apps with a simple and easy to use experience for broadly and frequently used SAP software functions that work seamlessly across devices – desktop, tablet, or smartphone.

Experience SAP Fiori:

http://experience.sap.com/fiori/

See it on SAP HANA Marketplace:

SAP HANA

All things SAP Fiori

All Things SAP Fiori

Fiori Apps Library

Fiori Apps Library

Fiori Confuguration Overview:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/500de2f4-67fb-3010-c194-cb98eb3fffd8?QuickLink=index&…

Architecture:

  • Fiori Client
  • Netweaver Gateway (on ABAP)
  • BW

SAP BW(7.3+) ——–>   RFC ———> NetWeaver Gateway 7.4 ———–> HTTPS ————-> Fiori Apps

Steps that needs to be done in SAP BW side:

1) Create a Bw Bex Report using Bex Query Designer.

2) Make the necessary settings by adding ‘By Easy Query’ and ‘By OData’ options in Bex Extended tab.

/wp-content/uploads/2015/06/1_729717.png

3) In our Case : Technical Name of the Query is ‘ZSALES_ANALYZER_FIORI’ and Description is ‘Sales Revenue Analysis in Fiori Tile’

  /wp-content/uploads/2015/06/1_729717.png/wp-content/uploads/2015/06/1_729717.png

4) When we do the settings as mentioned in Step 2, we will be seeing an entry in ‘EQMANAGER’ Tcode in BW.

/wp-content/uploads/2015/06/1_729717.png

When we click on ‘Test Easy Query’,the corresponding URL and the Bex Output would be shown.(In our case, the URL is the following)

https://XXXXXXX/sap/bc/gui/sap/its/webgui?sap-client=800&~transaction=*EQPREVIEW%20P_WS=/BIC/NF_30;DYNP_OKCODE=WB_EXEC

In case if we want to bypass the credential request, we can change the link to the following:

https://XXXXXXX/sap/bc/gui/sap/its/webgui?sap-client=800&~transaction=*EQPREVIEW%20P_WS=/BIC/NF_30;DYNP_OKCODE=WB_EXEC&sap-user=<  >&sap-password=<  >

How to enable EQMANAGER Tcode in BW:

Use transaction SBGRFCCONF for EQMANAGER configuration.

http://help.sap.com/saphelp_tm90/helpdata/en/35/0da8627e8040ada63550cf1fee5f6d/frameset.htm

Steps that Needs to be Done in SAP GATEWAY System:

5) Log into the Gateway System by providing the user name and Password

6) Enter the transaction : LPD_CUST to create a Launchpad role. Here I have created a role ZC_BWQR_00

/wp-content/uploads/2015/06/1_729717.png

7) Double click on the Launchpad role and create a New Application.

/wp-content/uploads/2015/06/1_729717.png

8) Enter the details for the following in the Link Details Screen.(The details purely depends on your requirement)

i)  Link Text,

ii)  Description,

iii) Application Type as URL

iv) The actual URL(that we got in Step 4)

v)  Application Alias

NOTE: Following is one of the main screens in Fiori where we can configure various types of Application Types mentioned below:

1) BI Web Template

2) Cystal Report

3) Infoset Query

4) List Report

5) Object Based Navigation

6) Portal page

7) Report Writer

8) Transaction (Backend Transactions for Example :  ME23N -> Display Purchase order)

9) URL(Lumira, Crystal Reports, BW Bex reports)

Visual Composer XApps

Web Dynpro ABAP

Web Dynpro JAVA

Xcelsius Dashbaord

/wp-content/uploads/2015/06/1_729717.png

System Alias field is required in case of calling the transaction from backend system or specifying the webdynpro from backend system. If it is URL type, then system alias is not required.

Also please note that only HTTPS links can be configured in Fiori.

9) Proceed without providing the Name Space

/wp-content/uploads/2015/06/1_729717.png

10) Create a Semantic Object using Tcode –> /n/UI2/SEMOBJ . Here we have created ZBWBEXQUERY. To avoid confusion, we can even give the same name in all the columns

/wp-content/uploads/2015/06/1_729717.png

Click on SAVE button and save the configuration under a transport request.

Steps that needs to be done in Fiori Admin Page

11) Take the Fiori Admin Page and provide the required Credentials:

https://XXXXXX/sap/bc/ui5_ui5/sap/arsrvc_upb_admn/main.html?scope=CUST

12) Create a Catalog by using the following  + Button:(Available in Left Bottom Corner)

/wp-content/uploads/2015/06/1_729717.png

13) Enter the Title and ID(As per your Requirement)

/wp-content/uploads/2015/06/1_729717.png

14) Click on + Icon:

/wp-content/uploads/2015/06/1_729717.png

15) Click on ‘App Launcher – Static’

/wp-content/uploads/2015/06/1_729717.png

Generally these are different types of tiles are available.

Static Tile: Show predefined static content.

Dynamic Tile: Show numbers that can read dynamically.

News Tile: Flips through news messages according to the configuration of the tile.


16) After clicking App Launcher – Static, you will be able to see the following screen:

/wp-content/uploads/2015/06/1_729717.png

17) Click on the ‘Tiles’ option and enter the General details:

/wp-content/uploads/2015/06/1_729717.png


The Title and Subtitle given here would be seen in the Fiori tile after configuration. So Provide the name accordingly.You also have the option to give the display icon here.


18) Enter the navigation details:

/wp-content/uploads/2015/06/1_729717.png

Provide the semantic object created in Step 10.


19) Click on SAVE Button and Confirm the Changes as OK

/wp-content/uploads/2015/06/2_729692.png

20) Click on the ‘Target Mapping’ option and click on ‘Create Target Mapping’ Button available in Right bottom corner

/wp-content/uploads/2015/06/1_729717.png


21) Provide the details in the Indent Screen.

/wp-content/uploads/2015/06/1_729717.png

Provide the semantic object created in Step 10.


22) Enter the details in the Target Screen:

/wp-content/uploads/2015/06/1_729717.png

Enter the Launchpad Role (created in Step 6) and Application Alias(created in Step 8)

23) Proceed by Saving the Configuration changes:

/wp-content/uploads/2015/06/1_729717.png

Roles and Users related Steps that needs to be done in Gateway System:

24) Log in to the gateway system and enter the transaction PFCG

Create a Single Role and Provide the description and save the role.

/wp-content/uploads/2015/06/2_729692.png

25) Click on Transaction drop down and Select Fiori Catalog:

/wp-content/uploads/2015/06/1_729717.png  /wp-content/uploads/2015/06/2_729692.png

26) Select the Catalog that you have created in Step 13 and click on SAVE option.

/wp-content/uploads/2015/06/1_txt_729703.png

27) Click on User tab and add the user who would be launching the tile from Fiori Designer page(in my case, user is KPIDEMO)

/wp-content/uploads/2015/06/1_txt_729703.png

Steps that Needs to be Done in Fiori Launchpad:

28)  Take the Fiori Launhpad Page and provide the required Credentials:

https://XXXXXX/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html


29) Select the Tile Catalog after selecting the List Icon.

/wp-content/uploads/2015/06/1_txt_729703.png –> /wp-content/uploads/2015/06/2_729692.png

30) Search and Select the Catalog created in Step 13.(In our Case ‘Sales Revenue Analysis’ Description)

/wp-content/uploads/2015/06/1_729717.png

31) Add the Tile to the any Group in Launchpad(Here am adding to the ‘My Home’ Group.

/wp-content/uploads/2015/06/1_729717.png

32) Now the configured tile would be appearing in the Fiori Launhpad Home Page of the user KPIDEMO

Untitled.png

33) Now Click on the Configured Tile and you will be able to see the BW Bex Query Output.

/wp-content/uploads/2015/06/1_729717.png

Hope you were be able to follow the steps and configure the Bex Report in Fiori Custom Tile.

Also, please note that this is just one of the method through which we can configure a Bex report in Fiori,

Another option has been explained by Gavin in the following Blog:

SAP BEx Query to Fiori App – From ASUG MN 2015

BR

Prabhith

To report this post you need to login first.

8 Comments

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

  1. K Prabhakaran

    Hello Prabit,

    Very nice step by step document on \Fiori and Bex Integration.

    Thanks for all your effort.

    Bookmarked.

    Thanks and Regards.

    KP

    (0) 
  2. Shashank Gupta

    Hi Prabhith,

    Thanks for detailed document.

    After configuring it on same way, when clicking on Tile, I am getting below screen.

    What can be the reason?

    Regards-
    Shashank

    (0) 

Leave a Reply