Empty values "In List" or "Prompt"
I'm trying to create asset accounting reports in webi with the data coming from BW.
This is what I have done...
I have created a DSO based on the standard SAP template 0FIA_DS13 and then loaded the data, including those asset master data into it.
After that I setup a connection in Universe to connect BO to that DSO directly.
And then after published the Universe and I created a webi report with it. The data seems to be okay without any problems.
However when i change the query and add a filter to one of the field, such as company code, using In List "values from list", it returns no data.
I'm pretty sure there is data in company code, just that the list of value is empty when i use "In List" or "Prompt"
I'm wondering if there is any extra setting that I need to set in Universe? or in BW? or i need to add some patch (we are using BO 4.0 SP7 currently) as i read some posts before....?
Thanks in advanced.