Skip to Content
avatar image
Former Member

too much value in filter value list when running bex query

Hi There,

I have a info-object 0CALMONTH, and in DEV and PROD, its latest value for a multi-provider is 201611, and 0CALMONTH is used for customer exit variable in bex query in this multi-provider,

and 0CALMONTH used in characteristic restrictions in the bex query, which set 'access type for result values" as "posted values".

and for 0CALMONTH property, in 'business explorer' tab , set as follows:

but when I run bex query using bex analyzer, and trying to select value for customer exit variable of 0CALMONTH, I got a long list up to 205012, but the max value for 0CALMONTH is 201611 in the multiple-provider.

capture.jpg (59.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 03, 2016 at 04:49 PM

    Hi Zang,

    At BEx 0calmonth properties, please select only posted values for navigation and see.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2016 at 05:47 PM

    I already set the same, following is the setting for 0CALMONTH in bex query (no issue in PROD, but issue in DEV, the setting for 0CALMONTH are the same in bex query and info-object property between DEV and PROD)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2016 at 08:46 AM

    Have you written any ABAP code in customer exit? And if i got it right you don't want full list of values for month '0CALMONTH' but only max value as '201611' needs to be fetched in BEx. Am I getting right?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2016 at 01:33 PM

    Yes, correct. I attach code below for your reference, I don't think this relevant to that big year/month list.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2016 at 05:49 PM

    Hi,

    I find this is caused by a extra infoset for the multiprovider, which is not deployed to PROD yet, I checked all dates in multiprovider in DEV and PROD, there max date is current month. I am wondering why I add in an extra info-set into multiprovider, this will cause a lot extra date values in prompt created on 0CALMONTH?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2016 at 07:49 PM

    can anybody help out here?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2016 at 05:32 AM

    Similar Issue Please check this post.

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded