I am using Dashbaord Design 4.1 and BO 4.1… I have a webi report and passing a value from dashboard to this report.
My report data looks like this
Region1 Region2 Region3 Sales
I want to show sales say for region North… I want to see all the rows where North is present in Region1 or region2 or region3… I mean show me all the rows where North is either in Region1 or Region2 or Region3…
How do i implement this logic through BIWS… I searched but could not find something which is “Like” Operator.
To the best of my knowledge, web services cannot filter results based on “like” or “matches pattern”.
You can do some wacky workarounds in which you bring in all of the data, then use FIND or SEARCH within the Excel to extract the values you want. Those kind of workarounds generally have poor performance, are error prone, and are not possible with some data structures.
The simpler solution is to use prompts rather than filters. Prompts can leverage “matches pattern”. The downside here, of course, is that to use the prompt you must refresh the report. This can be detrimental to performance, depending on how long it takes the report to run.
In certain cases, you might be able to do other workarounds at the report level. For instance, suppose you know that the only allowable filters are North, East, West and South. Create four variables in your report. The first returns 1 if North is in the name of one of the regions, and 0 if not. Repeat for the other three values. Then set your filter to check this variable. This only works in cases where you have a finite (and preferably small) number of possible filter values.
One way is passing the value to the webi filter. But we wanted to get all the data and then handle it at the dashboard level.
so I concatenated the first 3 columns “region1region2region3” which will give me all the combinations. and then using the “Find function” on dashboard to match the string. till here i am able to achieve it…
Now if it matched the string I get 1 else 0… Now my problem is how do i filter the 1 from this list.
1
1
0
0
1
0
1
0
I only need to filter on 1 on dashboard.. so that my data should look like this.. I tried different functions. but was not able to get all the 1 from the list.
1
1
1
1
Is there a way to filter all the 1’s on the dashboard one after another. I mean just filter the rows with 1.
(BOB member since 2005-01-28)