on 08-24-2010 1:09 PM
Howdy?
We've created a BEx report which is working fine except for the selection choices for a filter.
Here's what happens: A filter variable Currency (optional) (0CURRENCY) offers only # - Not assigned, and USD - US Dollar as selection choices. Thing is, if I enter, say, EUR in that dialog as currency and click on OK, the filter is correctly loaded with Euro and all figures in the report are correctly displayed in Euros.
What I can't seem to figure out is why the selection menu on Currency doesn't offer more than those two choices - I've set "Maximum Records" to 1000.
I've also verified that 0CURRENCY has the correct master data, which, of course, is confirmed by the correct results on the report side.
Any ideas anyone? Please don't hesitate to ask if anything is unclear. I'll be happy to provide a screenshot.
In the Query Designer, click on 0CURRENCY and check what option you have selected in the Properties / Advanced tab / Filter Value Selection During Query Execution section...
Try checking "Values in Master Data Table"... Since you say the Master Data has been properly loaded, it should show...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Advanced -> Access Type for Result Values - Posted Values
Advanced -> Filter Value Selection During Query Execution - Values in Master Data Table
I must note that we're not using 0CURRENCY directly but through a variable and conversion type. I just checked ob08 and it looks maintained. I also checked the data in 0CURRENCY directly and it's filled. There must be something I'm missing. I'm puzzled.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.