I’ve noticed that whenever you attach any sort of function to an object like rtrim() or create a variable that displays the concatenation of 2 objects, the dynamic filter in the Webi report does not work. Instead of the anticipated unique values list upon selecting “filter”, you see only “” in the list box.
Is there a way to get around this? Maybe this is a Webi limitation thing?
There has to be something else going on. Webi doesn’t know that you have applied SQL functions or concatenations. It just gets the results of the query. I haven’t seen this, but I have used the filter on concatenated SQL objects with no problem.
Is it consistent? In other words, does it happen every time you use this type of object, and no other time?
Yes, it’s consistent. I have never been able to use the dynamic filter in Webi reports where the field (object) is subject to a function or concatenation. As soon as I remove these and go back to just the pure object from the universe, the dynamic filter works fine. Try it out. Create a simple query…two or three objects. Then, in report edit mode, create a variable against one of the dimentions using the simple rtrim() function. Drag the variable into report. Save to corporate documents (view interactive HTML) and try to filter. You will see what I’m talking about. Let me know what you find.
OH, I see what you’re talking about. I misunderstood. I thought you were talking about rtrim on the object’s select (in Designer).
Yes, I have seen this. The filter can only be applied to values in the Microcube. Therefore, variables cannot be used like that in filters. And I don’t think there’s any workaround other than putting the logic in the universe. Is that an option?
Thanks, for the reply .I tried by capturing the user response to rank on Top N(where N is read from user input) converted that in to a number and tsaved that in to variable, then applied rank function on the variable.It didn’t work .Also, I am using Bex queries as my source for the universe.Can you please elaborate a little bit more on this.