Report filter value won't work when manually typed in?

[Former Member]

Has anyone seen this before? If I manually type the value in the "Type a value:" field, and click the > arrow to send it to the selected value(s) and click ok it will not filter using that number. i also notice it shows a key icon next to the number when it goes over to the selected value list. If I do select the value from the list below already generated and send it over to the selected value(s) list it will filter correctly. I'm asking because we're trying to manually input a bunch of values so we don't have to look up each one individually. Any help would be appreciated.

[Former Member]

This is on a BEx connection, not a universe. We've checked the BEx in IDT and we don't show there to be any spaces before or after the value.

[tanveer1]

Is it happening even if you use dimension rather than key attribute as a prompt ?

[Former Member]

It doesn't do it when I use a prompt, but that is done with a query filter. I'm having this problem when I use a report or page filter.

[former_member723440]

Try creating a dimension in IDT for the field to remove the trailing space by usine a Trim function, and import that dimension in the WEBI to use.

Hope this helps.

[Former Member]

Hi,

It´s a text object ? If so, test for trailing/leading spaces in Sold-To-key.

Regards,

Rogerio