I have an issue in a report where I think the source lies in the framework, so I post it as a Framework issue:
In a report (relational package) I have a filter on one item. If I say in the filter that [data item] = 'X', it works. When I say [data item] IN ('X') it also works. When I say [data item] in ('X','Y') it fails with an error:
QE-DEF-0261 RQP - Parsing text: [Account Country Code] in ('AT','BE','BG','CZ','CY','DE','DK','EE','ES','FI','FR','GB','GR','HR','HU','IE','IT','LT','LU','LV','MT','NL','PL','PT','RO','SE','SI','SK')RQP-DEF-0149 The query specification is incorrect.RQP-DEF-0457 Referenced Query 'q_pieces_year-1' is not defined or its query items contain unresolved references.
As far as I know all is standard in the Framework regarding this data item. What am I missing that causes this error?
Who in the all-knowing and Always helpful Cognoise community knows which long toe of Cognos I stepped on and will share it with me?
Hi,
Is the [Account Country Code] in the query subject 'q_pieces_year-1'? Try creating a filter with an 'or' condition and let us know if the issue still persists.
Good luck
New guy
First it was not, now it is. The thing is that the whole thing worked perfectly on another package with the same filter condition. Now that I update everything to a new filter, this starts to complain with the error. And it doesn't complain when I use only 1 value in the IN, or use a regular = instead.
I've often encountered this when working in a multi-language, or non-English environment (don't know if that's your case). The fix is to use semi-colon instead of comma as your separator. Try this:
[Account Country Code] in ('AT';'BE';'BG';'CZ';'CY';'DE';'DK';'EE';'ES';'FI';'FR';'GB';'GR';'HR';'HU';'IE';'IT';'LT';'LU';'LV';'MT';'NL';'PL';'PT';'RO';'SE';'SI';'SK')
You're right. I am surprised, because I tested this already, as I know this issue all too well. Also, I wonder how it worked previously, since I usually work in English to develop reports. Anyway, it's solved!
It still gives the unresolved issue when I use the short name of the data item from the query, but maybe that is because there is a condition in the query item?
QuoteIt still gives the unresolved issue when I use the short name of the data item from the query, but maybe that is because there is a condition in the query item?
Don't know. I'd like to help, but you'll have to give more details, such as the definition of this problematic data item.
Thanks for the offer. We now have an extra consultant here who experiences the same issue and is frying his brain over the source of the issue.