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)*
*Figure 2 – Sample Application (after clicking hide currency)*
*Figure 3 – Sample Application (after clicking show currency)*
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.
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):*
*Figure 5 – Web Template with Toggle Buttons (after click):*