We created Webi reports on top of Bex queries.
In Lovs for prompts we are seeing all the values from that characteristic's Master data where as we want to see only the values from Transaction data.
We already changed 'Filter Value selection During query Executiion' to 'Only Posted Values For Navigation' but it didnt help.
Because of this, we are seeing a big list of values from master data and it takes a lot of time to refresh. We also see some junk values that are present in master data.
For example, for Fiscal Period, we have data only from FY 2000 but we see Lovs from 1970s.
Please help with your inputs.