Dynamic filter issue

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?

Thanks :confused:


korzel :us: (BOB member since 2004-01-20)

Kevin,

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?


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

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.


korzel :us: (BOB member since 2004-01-20)

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?


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I’m resolving at the database level. Thanks. I thought I was up against a wall on this one.


korzel :us: (BOB member since 2004-01-20)

Can I expect that to be fixed some day? from my point of view that’s a big limitation compared to the full-client version

Thanks,


Schuster :united_arab_emirates: (BOB member since 2002-08-29)

You can certainly submit an enhancement request. Business Objects is very good about listening to their customers.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Hello All,

I have a report that needs same kind of functionlity using BO XI 3.1 SP2.Were you able find any solution for filtering based on a varaible value?

Please let me know.

Thanks in advance.


raj3685 (BOB member since 2009-10-25)

Hi All,

I think in BOXIR3 SP2 vesion , we can apply filtering on the variables & it can be implemented on the Reports.

Please let me know if my information is incorrect.

Thanks,

NewtonsApple


NewtonsApple (BOB member since 2009-08-11)

A filter can be applied to a variable using the Where operator.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Hello,

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.

Thanks


raj3685 (BOB member since 2009-10-25)