Few important commands in WAD in SAP BI - Part1

[Former Member]

Web Application Designer (WAD) is used to design templates for the report embedded in it. Usually report simply provides an excel based output. In addition to this WAD can provide some extra functionalities or properties such as Links, Buttons, Back screens, Filter panels, Tickers, Drop downs, Radio buttons, List boxes, Hierarchical filter selection, Info Fields etc to the existing report. Here in this blog I would like to share few important commands used,

Suppression of Messages:

While executing the Bex Reports, sometimes we may come across some warning messages, which are not much harm for reports, but Users may feel that there is some issue with the reports. So in this case we should suppress those messages, this can be done through WAD using the Web Item "System Messages". We need to suppress the messages by selecting the property Visibility as "Hidden". Please find the below screenshot where the setting needs to be done,

Filter on Selected Record:

Sometimes users may like to filter a row based on a field (For Example: Organizational Unit). Please find the initial data available in the report below,

Organizational Unit	Organizational Manager	Employee	Location	Country
Sales	Karl	Nichol	New York	USA
Sales	John	Martin	New York	USA
Sales	Randy	Micheal	London	England
Finance	Eva	Jana	Munich	Germany

When User selects a row (Organizational Unit) on "Sales", User should see only data related to the Organizational Unit "Sales". Please find the data how it should display,

Organizational Unit	Organizational Manager	Employee	Location	Country
Sales	Karl	Nichol	New York	USA
Sales	John	Martin	New York	USA
Sales	Randy	Micheal	London	England

To achieve this type of functionality we should as below,

1. Create a Button using the Web item "Button Group".
2. Edit the description of the Button to "Filter Selected" and select a command "SET_SELECTION_STATE_BY_BINDING". Please find the details in the below screenshot,

3. Add the field for Selection after selecting above command.

As per the above screenshot, whenever user clicks on the row based on the field "Organizational Unit", it will filters out that data only and show as output.

How to remove filter after selecting a filter on a Row:

1. Create one more Button and name as Back to Initial.
2. Select a command "BACK_TO_INITIAL_DP_STATE". Please find the details in the below screenshot,

After selecting the above command, the screen of the report will move to the initial screen as below,

Organizational Unit	Organizational Manager	Employee	Location	Country
Sales	Karl	Nichol	New York	USA
Sales	John	Martin	New York	USA
Sales	Randy	Micheal	London	England
Finance	Eva	Jana	Munich	Germany