Skip to Content
0

too much value in filter value list when running bex query

Nov 03, 2016 at 03:19 PM

81

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Raman Korrapati Nov 03, 2016 at 04:49 PM
0

Hi Zang,

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

Thanks

Share
10 |10000 characters needed characters left characters exceeded
BO ZHANG Nov 03, 2016 at 05:47 PM
0

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)


capture.jpg (82.1 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi,

please lets try to re-generate your query from RSRT and see.

Thanks

0
sumeet durgia Nov 04, 2016 at 08:46 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
BO ZHANG Nov 04, 2016 at 01:33 PM
0

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


capture.jpg (39.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
BO ZHANG Nov 07, 2016 at 05:49 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
BO ZHANG Nov 08, 2016 at 07:49 PM
0

can anybody help out here?

Share
10 |10000 characters needed characters left characters exceeded
Las W Nov 09, 2016 at 05:32 AM
0

Similar Issue Please check this post.

Thank you.

Share
10 |10000 characters needed characters left characters exceeded