Skip to Content
Former Member
Dec 29, 2014 at 08:28 PM

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!!