Andy Farrar

I have implemented the solution suggested in post "Problem with searching in Excel's Filter Drop DownList" by using reJ to alter the relevant bytecode in the mondrian jar file. Tested it over the last couple of days and it seems to be working well.

Further experimentation shows this is the same problem as "Problem with searching in Excel's Filter Drop DownList" posted by Vladimir Cibulka on Wed Mar 23, 2016. The problem goes away if we ensure that all of our dimension caption columns are lower case only, which is consistent with the explanation already provided on that previous post.

Mondrian running on Jasper Server Search filter on the "Row Label" and "Column Label" does not work if you enter whole word, but works OK if you don't enter first character of word. This happens regardless of case, at all levels of all dimensions in all the cubes created so far. (Apart from this problem, XMLAConnect is brilliant, working really well). Example: We have a customer type "Internal Accounts". If we type "nternal" or "ccounts", in upper case or lower case or mixed case, the customer type...