Input Variable in BO Webi Report

[moha_nan]

Hi,

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?

Thanks

[Former Member · Accepted solution]

Hi,

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".

Best regards