How to Add a New Filter Value in BEx WAD to Display All Result

[Former Member]

Hi experts,

I want to add a new filter value in BEx WAD to display all data records. The scenario is as follows:

The status field can have two values: Active ("A) and Inactive ("I").

But the requirement is to have a third value to display all the data records (Active + Inactive). E.g. the value can be "G". The purpose is to increase the understandability for report users.

Does anyone have an idea?

Regards,

Joon

[Former Member]

Hi,

any information regarding this question?

Thanks,

Joon

[former_member183777]

Assuming you are using a dropdown to implemnt the filter. Dropdown has a property to Display All Values. Just set the property and drop-down will show you 3 entries. Active, Inactive and All values.

[Former Member]

Hi Vineet,

thanks for your reply. The problem is that there are only 2 values available for this Characteristic: "A" or "I".

The requirement is to have a third value "G" (instead of the default "All Value") due to historical reason, because all future report users have been working with R/3 reports for quite some time and they are accustomed to using "G" for displaying all values.

Is there any possibility to realize this?

Thanks,

Joon

[former_member183777]

Since there are only 3 values, implement a drop down with Manual list of values. For the action you can implement a Javascript function using the script item, or you can create a regular command for each value to implement the filter. Value G would use the command to remove filter value.

[Former Member]

Hi Vineet,

it sounds like a good solution to my problem! Do you have any example or links regarding how to implement filter using Script Item?

Regards,

Joon