Skip to Content

h5. Introduction

In this blog, I will show an example of the power of BI Commands within the BEx Web Application Designer in SAP NetWeaver 2004s BI. In this scenario, I demonstrate how you can show/hide a particular characteristic from displaying within your web application while keeping the data table as input ready for a planning enabled BEx Query! This will allow you flexibility in your presentation layer versus your integrated planning input layer.

h5. Here’s an example view

The example application looks as follows:

*Figure 1 – Sample Application (default view)*

image

*Figure 2 – Sample Application (after clicking hide currency)*

image

*Figure 3 – Sample Application (after clicking show currency)*

image

As we see here, the query has Fiscal Year, Currency, and Version. These are all required to be in the rows to be at the lowest of the query for planning. Therefore, this solution shows how you can be at the lowest level, but hide the display of a particular characteristic from your table. If you utilize this method, keep in mind that the data will be written for this particular “hidden” characteristic value. In general, it is recommended that the characteristics you plan on are specified in the query and not directly in the web application to drive the most consistency. This solution just shows how to control the presentation layer.

h5. Implementation

To implement this solution is very straightforward. We are using the command “SET_PRESENTATION” within the Command Wizard in the BEx Web Application Designer. The values for this presentation can be found in the online help here: http://help.sap.com/saphelp_nw2004s/helpdata/en/43/d8c6dcc0700235e10000000a11466f/content.htm .

h5. What Next? – Toggle Buttons!

So now you’re probably thinking, hey, he’s got two buttons there. That takes up screen real estate. Why doesn’t he make that a toggle button. You can do that as well! The online help has an example of toggle buttons here: http://help.sap.com/saphelp_nw2004s/helpdata/en/43/935812ff0b274ee10000000a422035/frameset.htm . Definitely worth checking out.

*Figure 4 – Web Template with Toggle Buttons (before click):*

image

*Figure 5 – Web Template with Toggle Buttons (after click):*

image

To report this post you need to login first.

12 Comments

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

  1. Victor Figueroa
    Prakash, Hi i you article is very help me.

    I need know if can help in this problem.

    I required this Complex Screen for the Planning Datas filter by Cost Center value.

    Check Red Areas.
    http://fotos.subefotos.com/32310791c822b71c97330764ba4ea890o.jpg

    So, text areas si required the BOSS the AREA can look in some Aggregated Report and look the Box Texts Inserted in the Screen for Planning.

    Thank you, for you time, i really need fix that complex problem.

    (0) 
        1. Prakash Darji Post author
          If you have the texts modeled as part of the dataset, you can just drilldown by this field. If you have the texts stored as documents within KM, then they can see the document icons on the transactional lines.
          (0) 
              1. Victor Figueroa
                Hi, but when in BW 3.5 you attach txt file or word for the infocube value, that is stored in the metadata or mime, is not posible get the list the documents in the metadata or mime, and open when need look inside ?

                Thank you, any away…

                (0) 
  2. Arpit Seth
    Hi

    In my case there are some attributes attached to the Characterstics, i can see them going through context menu. But i am not able to add them in the table.
    Can you please help me out.

    Thanks a lot
    Arpit

    (0) 

Leave a Reply