BusinessObjects Board

Dashboard - web service filter & list box

other Xcelsius - Crystal Dashboard Design
#1

I have created a webi report (4.1 version) and focusing on a table with 4 columns and 6 rows.

I have created a web service (for this table), using the filters as well.
In the filters a I choose the 4 columns but also another field.

While testing the web service, it brings the data of the report table.
Trying to apply filtering on the web service test (all these from the webi report), it did not regognise the text values I put and brought 0 as a result.
After, ‘google’ the issue, I inserted many characters with the space bar and then I inserted the text again (played around a bit) and it worked. It brings the filtered data.

Now, I created a dashboard (4.1), utilizing the above web service with one list box and one scorecard.
In the list box, I put as labels the text I mentioned above, so that in the scorecard I present the filtered data by label.
Although, I managed to bring/present the ‘complete’ set of data of the table, It does not show the filtered data.

I have the feeling that it might be something (workaround), like ion the web service filtering from the webi report.

Does anyone know something about it?

Thank you,

Nektarios

psycharisn (BOB member since 2012-07-03)

#2

finally, I found a workaround with combo box, while selecting filtering from this.

Nektarios

psycharisn (BOB member since 2012-07-03)

#3

Hi, can you please tell me how did you worked out with it, I’m working on something similar, I can filter the values but I need an “ALL” selection from the combo box to display the entire data. what filter value should be given to the webservice, to display the entire data?!

Praveenyennam (BOB member since 2015-12-31)

#4

The easiest solution I’ve found is to create a cell with a formula like:

=IF($A$1 = “ALL”,“NOT_EQUAL”,“EQUAL”)

Then just point your operator to this cell. If the user selects “ALL” then the filter becomes “not equal to ALL”. Otherwise, it is equal to the selected value.

Lugh (BOB member since 2009-07-16)