Input Variable in BO Webi Report
We have BW-Query and have defined BO Webi-Report using Universe on this query.
When we execute BW-Query direct in BW, we can see all plants from
master data table in the input Variable (Input help/F4).
When we execute BO-Report in BO, it shows only plants in the input variable, for which there are transaction data
in InfoCube. I expect here to see all plants from the master data table (like BW Query).
Is it normal? Or is there some other issue?
Victor Gabriel Saiz Castillo replied
as the webi report will contain only transactional data anyway (webi MDX statement will ask for non empty records), this is the normal behavior what you are experiencing.
What settings do you have on the infoObject, on which you have the variable set?:
-Query Def Filter Value Selection
-Query Execution Filter Val. Selection
There you should be able to choose between "Only Values in InfoProvider" and "master data".