Skip to Content
Author's profile photo Former Member

Setting Presentation of Characteristic within BI-Integrated Planning Web Applications

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

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      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.

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      You can do this with the BEx Analyzer. Use Integrated Planning in BEx Analyzer and you can use excel formatting to achieve this.
      Author's profile photo Former Member
      Former Member
      Using that Texts Areas is related to Cost Center value, but HOW the Admin in the Superior Area can look all texts inserted the all sub-areas ?

      Thank you.

      Author's profile photo Former Member
      Former Member
      Blog 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.
      Author's profile photo Former Member
      Former Member
      Hi, so using the meta data repository or mime repository ?

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      If you use the document storage, it uses KM on the portal to store documents.
      Author's profile photo Former Member
      Former Member
      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...

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      These are stored in the metadata. You can get this from there.
      Author's profile photo Former Member
      Former Member
      You know some sample in the NetWeaver 2004s BI ?

      Thank you, man..
      very thank you ..

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      I don't have samples anymore as I did this at a customer where I am no longer...
      Author's profile photo Former Member
      Former Member
      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author
      Please post this question in the BI Forums as this is unrelated to this blog...