Skip to Content
avatar image
Former Member

Web Intelligence (4.1) 0CALMONTH2 prompt issue

Hi!!

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

Arturo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 30, 2014 at 12:41 AM

    Hi Arturo,

    It sounds like between operator is not taking into account that these are months and is doing the between on the literal strings.  For the Keys, it almost looks like it is treating these as strings as well.

    I remember this being a known issue in XI 3.1 and it was resolved about 4 years ago.  Perhaps it has resurfaced in BI 4.1 with BICS access.  XI 3.1 used MDX/UNV access as you may know so these are quite different.

    Might be worth opening an incident with support.  If you can open your SAP Router connection and supply a query support can test with, this can quickly be investigated.

    Thanks

    Jb


    Add comment
    10|10000 characters needed characters exceeded