Skip to Content
0
Former Member
Jan 06, 2012 at 06:12 PM

Unwanted LOVs - Universe on a BEx query on top of a Multiprovider

89 Views

BO XI 3.1

BW 7.01

OLAP Universe on a BEx query

BEx query on top of a Multiprovider

Multiprovider on 2 DSOs; lets say DSO1 and DSO2

BEx query has a global filter for "INFOPROVIDER = DSO1"

BEx query has a user input variable defined for "Field1" (Field1 is present in both DSOs)

In BEx, F4 on Field1 variable entry gives the values of Field1 from DSO1. (which is what we want)

Expected LOVs for the generated prompt for Field1 in the WEBI report: Values of Field1 from DSO1

Problem:

Actual LOVs returned in WEBI report: Values of Field1 from both DSO1 and DSO2

Has anyone faced this before?

Thank you