Skip to Content

SAP Design Studio apps, Crystal Reports, Webi reports etc. can now be integrated with the SAP Fiori Launchpad. In this blog we’ll look at how these reports/dashboards from the SAP BusinessObjects BI platform can be integrated with SAP Fiori landscape.


SAPFioriSAPBI.png


Before you jump on the how-to section, i recommend watching this demo video which shows how the reports/dashboards look in SAP Fiori launchpad.


Ok, I hope you watched the demo, now we’ll look at the how-to part.


The following walks you through the steps to integrate a SAP Design Studio application with SAP Fiori, however you can follow the same steps to integrate any report or dashboard with SAP Fiori.

Step 1: Generate the OpenDoc URL from the SAP BI Launchpad

  • Login to the SAP BI Launchpad and right click on the report or SAP Design Studio app that you want to make it available in SAP Fiori Launchpad, and select Document Link

     FIBI1.png

  • Copy the link to a notepad.

Step 2: Create New Launchpad

  • Login to SAP Fiori front-end server, and run transaction code LPD_CUST
  • Click New Launchpad, and enter the details as shown in the below figure.
  • Click continue

     FIBI2.png

  • Next, create an application by clicking New Application
  • Enter the details as shown in the figure

Link Text: Liquidity Forecast

Application type: URL

Paste the URL which we copied in Step 1 in Additional Parameters

Application Alias: LiquidityForecastApp

     FIBI3.png

Step 3: Create Semantic Object

            In SAP GUI, run transaction code /UI2/SEMOBJ, and add a new semantic object as shown in the figure below.

    FIBI4.png

Step 4:  Create a new Catalog

  • Login to SAP Fiori Launchpad Designer from your browser.

http://<server>:<port>/sap/bc/ui5_ui5/sap/arsrvc_upb_admn/main.html?sap-client=<client>?scope=CUST

  • Create a new catalog by clicking FIBI5.png
  • Select Standard, and then enter the below details.
  • Click Save

    FIBI6.png

Step 5: Create a New tile and the Target Mapping

  • Add a new tile in the Catalog by clicking FIBI7.png
  • Enter the General and Navigation details as shown below

FIBI8.png

  • Click Save
  • Now click FIBI9.png to add a target mapping. Enter the following details:

FIBI10.png

Step 6: Create a New Group

  • Select the Groups tab in the SAP Fiori Launchpad Designer.
  • Create a new group by clicking FIBI5.png
  • Enter the below details and click Save

          FIBI11.png

Step 7: Create New Role for the Catalog and Group

  • In the SAP front-end system, run transaction code PFCG
  • Enter a role name and click Single Role
  • In the role menu add the Catalog and Group which we created in the previous steps.

FIBI12.png

  • Click Save
  • Select the User tab and enter the user ID/ID’s who needs access to this SAP BI Catalog.

FIBI13.png

  • Click Save

Login to SAP Fiori Launchpad and you should now see the tile, catalog, and the group. Please watch the complete demo here.  


Happy Learning!

-Anil Bavaraju

SAP Press Author – SAP Fiori Implementation and Development

Img20.png

To report this post you need to login first.

49 Comments

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

  1. Mustafa Bensan

    Hi Anil,

     

    I assume that as a prerequisite to the above process we would also need to configure Single Sign-on between the Fiori Launchpad and BusinessObjects.  Is that right?

     

    Thanks,

     

    Mustafa.

    (0) 
            1. Jens Schwendemann

              Hi Anil,

               

              first thanks for the great blog and the valuable information provided.

               

              Is this correct, even if not using SAP (Netweaver) SSO product? As far as I know the ABAP Stack (we have a dedicated Fiori Frontend Server as a Hub) doesn’t support Kerberos out of the box, or I should better be saing “does technically support, but you aren’t allowed to use if you have no SSO license which is payed by user”.

               

              1. Is my knowledge (still) correct?

              2. Are there any other means of SSO from BO to FES like logon tickets?

              3. Did you integrate the FLP to enterprise portal while having all the subsystems connected as “Fiori Tiles”? And if so, did this work along quite well or was this iframe / config nightmare?

               

              Thanks and Cheers

              Jens

              (0) 
              1. Anil Bavaraju Post author

                Jens,

                Yes, we integrated FLP with EP, and it works quite well, we just have couple of issues related to cache, and session timeout.

                 

                Sorry, I am not really sure about the SSO license.


                Below authentication methods are supported, however i did not really explore which one of these works best with BO

                1. SPNego/Kerberos(with SAP NetWeaver SSO)
                2. SAML 2.0
                3. SAP logon tickets
                4. X.509

                 

                -Anil

                (0) 
                1. Jens Schwendemann

                  Thanks Anil, really appreciated

                   

                  at the risk of being a nuisance: When we would opt for 3. SAP logon tickets for SSO, would FLP (Fiori Frontend Server) be the issuing system then right (speaking of “direct” SSO without integrating in EP, first)

                   

                  Cheers

                  Jens

                  (0) 
          1. Andreas J.A. Schneider

            Well, the value is really in Ad-Hoc Reporting & Self-Service of Webi and its various, numerous data sources as well as additional features such as scheduling (to FTP, email, PDF, etc.), an export function to CSV/XLS/PDF worth its name, etc.

            Also, I have seen Webi reports that just look aweful, because the report designer made no effort whatsoever to design a pleasing report output. Of course the default formatting in Webi is of no great help here : (

             

            Last,  but no least, look forward to a vamped/ramped up Webi : )

            (0) 
  2. Ahmad Salam

    Hi Anil,

    1st thanks for the great blog.

     

    after completing the guide i get blank screen after trying the App on launchpad and i get error in the gw error log : The request URL or the metadata definition is incorrect.

     

    can you help with that ?

     

    regards

    Ahmad Salam

    (0) 
    1. Ahmad Salam

      Dear Anil,

       

      solved by this 2188358 – Handling of $ encoding in the Gateway URI

      however im seeing the report in the normal BI lanuchpad way not the Fiori Way

      (0) 
      1. Anil Bavaraju Post author

        Ahmed,

        Thanks for sharing the SAP Note.

         

        Please let me know what is that Fiori way you were expecting? I did not get that.

         

        -Anil

        (0) 
          1. Anil Bavaraju Post author

            Yes that’s correct, we are just integrating the Fiori and BI Platform, not converting the UI of a dashboard to the Fiori UI concepts. Do you will see the same UI what you see in BI platform.

            (0) 
  3. Athi-Ho Mlanjana

    Thanks Anil for the informative post. I have a question: is it possible for the Fiori launchpad to have a link that opens the SAP BI Mobile platform, instead of an individual report? We have quite a number of reports on our BI platform, and instead of having to integrate them all individually with Fiori, we would like to simply click or tap on a button and open up the BI platform (mobile) as a whole. The same way the SAP portal can have a link that opens the entire BI platform instead of a single report. Thanks.

    (0) 
  4. Szymon Glapiak

    Many thanks for this post. One qestion/remarks? Is the both servers(fior and BI) need to be on the same domain? Otherwise I got answer 403 as forbidden and  “Unsafe JavaScript attempt to initiate navigation for frame with URL”. I’m still fighting with this so all good advice  are welcome

    (0) 
  5. Syed G

    Hi Anil,

     

    Good post and its very useful. We followed all of your steps defined and its working successfully however the window is opened in a new tab, whereas in your demo its in the same iframe as of the fiori launchpad.

     

    Do you have any recommendations? Thanks

    (0) 
    1. Anil Bavaraju Post author

      Syed,

      If you follow step 4 – step 6 then it should open in the same window. If you are not using a semantic object and directly embedding the url in the target url, then it will open in a new window.

      (0) 
      1. Syed G

        I followed the same way as you showed Anil,  from step 4 – step 6 using Semantic Object. I’m finding it out to see what could be the reason, if you have any other suggestion?

        (0) 
          1. Anil Bavaraju Post author

            Syed/Jordi,

            Make sure the UI5 library is updated, you should then be good. I just faced this issue after upgrading to a upgrading it from 1.28 to 1.38, and then i updated it to the latest release, and now its working without any issues.

            -Anil B

            (0) 
  6. Murali Shanmugham

    Hi Anil,

     

    Thanks for the posting on this.

     

    In Step 2, You have provided the URL of the BI Report. How did you manage to transport this URL to the next system. You would have hardcoded the server name in your DEV and it would be captured as part of the transport which goes to PRD.

     

    Thanks,

    Murali.

    (0) 
  7. Satnam Singh

    Hi,

     

    Can i launch “Analysis for office” from Fiori Launchpad using a tile? I have Odata service (based on CDS) –> No BI/BW server.

     

    Regards

    (0) 
  8. Devisha Bhavik

    Hi Anil,

     

    Great blog to start for the integration.

     

    However, I have the same question as Murali about hardcoding the host name, port details in the URL section.

     

    Is there a way to avoid that so that when we transport to other systems, it reads from system alias or HTTP destination etc??

    (0) 
    1. karthik addula

      in the url section – type the url starting from/BOE…..

       

      create a sm59 http connection with target host as BOBJ system

       

      use the http connection name as system alias in the configuration (LPD_CUST)

       

      Thanks

      Karthik

      (0) 
      1. Devisha Bhavik

        Thanks.

         

        I actually figured that out after asking the question. the confusion was, when I did the F4 on the system alias field, it was not showing the alias I created in SM59. But when I typed it manually and tested, it worked fine!!

         

        not sure why it was not showing in the value help.

         

        -Bhavik

        (0) 
  9. Parandhaman GR

    Hi Anil,

     

    For this scenario, do we require SAP HANA?

     

    Can we use existing BW & BI/BO platform and a FIORI Front end server?

    As in our case we have SAP EHP 7 for ERP 6.0 and a dedicated Fiori Front-end server for transaction Apps.

     

    I see no where it is said HANA is mandatory, but a doubt as we are configuring the tile as “Analytical”

     

    Please comment on this to take-up the solution for implementation as our client is expecting both dashboards and transaction apps in one mobile entry instead of separate SAP BO Mobile.

     

    Thanks.

    (0) 
  10. Erik Fosser

    Hi Anil

    As Syed and Jordi already has mentiond; I also use a semantic object and still the BO reports opens up in a new tab. I use (to my knowledge) exactly the same steps as you are. Do you have any idea why a new tab is opened?

    Great blog by the way ūüôā

    Kind regards

    Erik

    (0) 
    1. Eriksson Björn

       

      Hi all

      I also get the same issue, the BOreport opens in a new tab.

      The strange thing is, if i press “Backarrow” in the browser, then the BOreport opens up within the Fiori Launchpad.

      Have you found a solution to your issue?

      Regards
      Björn

      (0) 
    2. Anil Bavaraju Post author

      Erik,

      Thanks!

      Make sure the UI5 library is updated, you should then be good. I just faced this issue after upgrading to a upgrading it from 1.28 to 1.38, and then i updated it to the latest release, and now its working without any issues.

       -Anil B

      (0) 
  11. Thomas Kast

    Hi Anil,
    I tried to implement that in our landscape and did all the steps described. If I lauch the Tile I get error
    :Message Launchpad ZBOEPOS / ANALYTICS / ZRT_POSM_CUSTOM_APP does not exist in client 100.
    Is there one step missing ? I doublechecked configuration and my LP is created and alos semobject ..
    I don’t know what is missing
    Thanks
    Thomas
     

    (0) 
  12. Priyanka Sadana

    Hi Anil,

    I tried to integrate a consumption CDS View used in Analysis for office with Fiori using FM RSAO_CREATE_LAUNCH_FILE. But it is not working.

    Please comment in case you have used  I_T_VARIABLES in RSAO_CREATE_LAUNCH_FILE to launch Analysis for office.

    Thanks,
    Priyanka

    (0) 
  13. Mehmet Batman

    Hi Anil,

    At first.thanks for the excellent blog.

    In an environment where a standalone HANA (inclusively XS engine) system is used for custom native development and data consumption is done by several BO Tools (Design Studio, Webi etc.) . Will there any Netweaver component needed when integrating those BO tools with SAP Fiori?

    Or are Netweaver components (ABAP Server, SAP Gateway, SAP Web Dispatcher) essiential for every SAP Fiori setup?

    Many thanks

    MeBa

    (0) 
      1. Con Pirzas

         

        Hi Anil,

        When I configure LPD_CUST¬†to use¬†a System Alias (because I don’t want to hardcode the URL in the Catalog Tile Target URL field), the BI report is launch within the same window as the Fiori Launchpad, and cannot be maximised to a full screen.

        When I hardcode URL in the Catalog Tile Target URL field, the BI report is launch in a new window, which is what I want…..any ideas on how to do this without hardcoding URL in the Catalog Tile Target URL field?

        thanks,

        Con

        (0) 
  14. Andre Jost

    Thanks for that blog post. How you configured the system to open the URL inplace? I think the inplace parameter within the LPD_CUST doesn¬īt take place.

    (0) 

Leave a Reply