Web Intelligence (4.1) 0CALMONTH2 prompt issue
Im having a problem in Web Intelligence,
Im using "Month" (0CALMONTH2) in the query filters as a "between" prompt (Month From: And Month To:).
At the moment I run the query and select for example:
Month From: JAN Month To: MAR.
The query returns information for: JAN, JUL, JUN and MAR
Also if I use the "Month Key" Instead of "Month" and select From 1 to 3; the query returns information for 1,2,3,10,11,12 (January, February, March, October, November, December)
This issue doesnt happen using the object "Month TechName" and neither by using "In List" instead of "Between".
Is there a way to workaround this issue (using "between" and the name or number of the month instead of the TechName)?
Thanks in advance!!