SAP BusinessObjects Design Studio 1.6 on SAP Netweaver Portal.  In the roadmap of SAP we learn that the way to go is to embed your Design Studio app’s to the SAP BusinessObjects BI Platform.  But this is not for all companies directly applicable.  For those who the SAP Netweaver Portal is the only platform available, I hope this blog is helpful.

  1. System & versions

    • SAP Netweaver 7.4
    • SAP BW 7.4 SP 15
    • SAP BusinessObjects Design Studio 1.6
  2. Configuration

    • Chapter 5: https://websmp101.sap-ag.de/~sapidb/012002523100019196712016E/ds_16SP04_admin_nw_en.pdf
    • Note chapter 5.8 Configuring the Report-Report Interface for Analysis Applications!
      • http://<server>:<port>\nwa to go to the Netweaver Administator
      • Restart the design studio Java applications in following order, not only .portal like in the SAP document
  3. Embedding Design Studio app’s on the SAP Netweaver portal

    • Portal Content > ABAP Roles >select or create role > add Iview from template > Design Studio > save > open wizard > add parameter: APPLICATION=”name of your DS app”
  4. Setup of Reporting environment

    1. Design Studio as replacement of the Web Application Template

      This would be the most ideal solution, to change swiftly all the reports to a neat Design Studio interface.  But this is sadly not supported by SAP now and in the future.  SAP is heading only for improvements on the SAP Business Objects BI Platform and will not improve the SAP Netweaver Portal.

    2. Design Studio app’s per Bex Query

      This solution I would recommend not to use.  As it has a high work rate to save manually each Bex Query in a Design Studio app.  Even if you reuse each time the same app.  Modifications on the reused app will be needed on each item saved on the platform.

    3. One App meets all

      The Netweaver Portal embeds one Design studio app as a portal interface.  Via that app you ‘ll retrieve instantly information and you will be able to jump to all bex queries related to it.  In this case you’ll only have to maintain 1 app.

  5. One App meets all – explained step by step

Old look of the SAP Netweaver Portal
New Look of the SAP Netweaver Portal

Direct Jump to the App –>

The interface as pictured above is build from scratch in the SAP BusinessObjects Design Studio application.  The goal of the interface is to give you a clear overview of your facts & figures of your business.  In the “Welcome (Welkom)” page we will show KPI from different subdomains all together in one view, those are the most used and most important facts the business want to know.  “Aanvragen”/”Regularisatie”/etcetera show all the facts & figures per subdomain.  Each tile represents thus a KPI.  In the headings of the tile we see the Bex Query name belonging to the KPI.  On mouse click on the tile we jump to a generic analysis template app that visualizes the go-to- Bex Query.  In the new window showing our BEX-Query we are able to jump via RRI to the same app including the jump-to BEX Query.

 

  1. CREATION of Main design studio app

    • Start creation from a standard app
    • HEADER / BODY /FOOTER
    • Header you define textcomponents as text
    • BODY contains a pagebook filled with the tiles
    • Allthough there are a lot of tiles, the performance is acceptable when you set the pagebook cache to all, it improves the user friendliness as well
    • Each panel contains the jump to the respect. query.
    • Code:TO_REPORT.Jump(TEXT_POOL.R_0_1);
    • Create global code
    • global script XURL to retrieve the server-url

      ID = Bookmark.saveBookmark(“URL”);

      index = Bookmark.getBookmarkUrl(ID).indexOf(“/irj/”);

      url = Bookmark.getBookmarkUrl(ID).substring(0,index);

      global script

    • XURL = url + “/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.designstudio.nw.portal.ds?APPLICATION=”;
    • global variables
    • XTEMPLATE (designstudio app used as adhocanalysis )& XQUERY=&XQUERY=
  2. CREATION of Query app

  3. CREATION of Jump to app (optional)

 

Details will follow in the next update

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply