webi report search filters not working as expected

[santoshbobj]

Hi All,
I am creating a webi report which implements Search functionality in BOBJ 3.1.

As There is no search functionality for input controls, I implemented an example as suggested from below site.

http://blog.davidg.com.au/2012/04/search-field-input-control-in-webi.html

Everything works fine nicely in Design mode or edit mode.

But the problem is in the View/Run mode of the infoview/CMC where the report is being run from.

The values are not being cleared for the "Search Variables" even though "Reset" button or backspace/delete button+OK button functionality doesnt seem to help.

Any ideas or help as to "What might be causing this"? or did any one face a similar issue. Please any suggestions is greatly appreciated.



I am stuck on this

[sateesh_kumar1]

Hi ,

before applying logic , place the variable in a blank cell and observe the value .

Which browser you are using ?

there shouldn't be any issue with logic in 3.1 . Make sure your variable is dimension type .

Thanks

[santoshbobj]

Hi Sateesh,

           The thing is it worked well in webi rich client but its not working from browser, We are using IE 11 and yes the variables are of dimension type as well

[sateesh_kumar1]

did you check the value in blank cell ?

Can you try in Chrome ?

you may need to enable Compatibility view / Enterprise mode to your IE

http://www.thewindowsclub.com/enterprise-mode-for-internet-explorer-11

Thanks

[santoshbobj]

I have tried it in chrome and behavior is the same. when you look at it this is how the variables are declared

Variable 1: Search by Role (declared as "")

Variable 2: Role Matches( formula : If(ReportFilterSummary(Report1)="") Then "Yes" Else If (Pos(Upper([Obj]);Upper(Trim([Search by Role])))> 0) Then "Yes" Else "No")

Then Filter on the report on filter pane "Role Matches In list: Yes"

These filter is tied to 2 objects

1) Webi chart block.

2) Detailed vertical table.

[sateesh_kumar1]

remove chart from dependencies and try

[santoshbobj]

for text search as used by the blog there is no dependencies its just that the report filter and formula combination makes it behaves like an input control as the entry field is tied to variable 1 and not an object as traditional input control) and the behavior is driven by the report filter function.

so  for the custom search function for entry field there are no dependencies.