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.

NOTE:

 

  1. System & versions

    • SAP Netweaver 7.4
    • SAP BW 7.4 SP 15
    • SAP BusinessObjects Design Studio 1.6
    • When upgrading to SP4, Basic layout will also not be available for SAP Hana and the ready to run templates (Data Discovery – Generic Analysis and Online Composition, will not be available on SAP Netweaver)
  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

    The interface  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
    • The tiles are panels containing Text & Icon components.
    • The tiles are via a CSS class Hoover enabled.  Name your css class (“myBackground” and add hover effect)
    • .myBackground:hover{
          box-shadow:  4px 4px 8px black;
          margin-left: 2px;
          margin-right: 2px;
          margin-top: 2px;
          margin-bottom: 2px;
      }
    • 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

    Query app uses the Generic Analysis template.  You’ll have to add this app to your SAP Netweaver Portal as well.  See chapter 3:”Embedding Design Studio app’s on the SAP Netweaver portal”.  The jump explained in previous chapter (5.1) will push through the variables: XSystem and XQuery.  The generic analysis template fetches those values and will open the specified query in the Design Studio App, because you will force it  by adding the XTEMPLATE parameter.

     

    url = XURL + XTEMPLATE + XQUERY + REPORT;
    
    http://<server>/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.designstudio.nw.portal.ds?APPLICATION=PORTALTEMPLATE&XQUERY=Z_TECH_NAME_BEXQUERY
    
    XURL --> <server>   &    /irj/servlet/prt/portal/prtroot/com.sap.ip.bi.designstudio.nw.portal.ds?APPLICATION=
    
    XTEMPLATE --> PORTALTEMPLATE
    
    XQUERY --> &XQUERY=
    
    REPORT --> Z_TECH_NAME_BEXQUERY
    
    ​

     

  3. CREATION of Jump to app (optional)

    Is 100% the same as the design of the query app.  But if you really want you can use another template.  It could be handy to force the prompts to pop up of the Query app, so business can (re)define the query.   It’s another behavior as when you jump from a line in the query to another query, more detailed and passing through the parameters of that line.  Sao that’s a choice up to you.

 

 

To report this post you need to login first.

7 Comments

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

  1. Agata L.

    Koen,

    This is really cool! A silly question – what type of a component you are using for “tiles”? Do the tiles have any on-hover effect? If so, would you mind sharing, please?

     

    (0) 
  2. Koen Hesters Post author

    hey Agata,

    They are panels, I’ll add it in my blog also. and I’ll explain the hovering

     

    .myBackground:hover{

    box-shadow: 4px 4px 8px black;

    margin-left: 2px;

    margin-right: 2px;

    margin-top: 2px;

    margin-bottom: 2px;

    }

     

    (1) 
  3. Sap Consultant

    Hi Koen !

    I really appreciate your post here !

    We have just migrated to BW on Hana, but we would like still to use our SAP Netweaver Portal (with webtemplates designed with WAD).

    I have some questions:

    1. Could you please show “again” the pictures  we can get with Design Studio app in SAP Netweaver Portal?       Is there some restrictions?

    2. When Lumira 2.0 (new Design Studio) is available ?

    and  SAP Netweaver Portal can still support a Lumira 2.0 app  ?

    Thank you very much for your help

     

    (0) 
  4. Koen Hesters Post author

    Hi,

    SAP LUMIRA 2.0 will only be deployable on BI platform.

    But note that will be “easy” to transform your design studio 1.6 apps to a lumira 2.0 designer version.

    grtz

    Koen

    (0) 
  5. Sap Consultant

    Thanks a lot Koen!

    Very nice your “Welcome” page, it looks like Fiori launchpad !  🙂

    is that the “One Design Studio App” embedded on the SAP Netweaver portal ?

    Can we use 2 environments together with our BW on Hana for the duration of the “conversion phase” of our current reports( webtemplates )  ?

    • Design Studio for SAP Netweaver portal
    • Lumira 2.0 for BI platform

    Thank  you so much!

    (0) 
    1. Koen Hesters Post author

       

      Hi,

      the all-in-one refers to the idea a lot of people had to be able to switch from the WAD template to a Design Studio template and so be able to open all their BEX reports via that Design Studio template.  This is a great idea, but simply not possible.  But via the solution in my blog it is.  You are able to hang one design studio app in the BI browser like a welcome page and you can enable jumps to all your queries and those will open in a Design Studio template.  (the template you’ll need to import in your BI Browser) and even if you use RRI, you will jump from query to query all using a design studio app.  The welcome-app will be like a middle station, from that point on you can create jumps to whatever you want.  We will use it indeed as a middle step in the “conversion phase”

      Grtz

      Koen

      (0) 

Leave a Reply