Hi All,
Any help would be appreciated..
We are trying the below scenario in BI 4.1 using BICS
We have a WebI report which consists of two WEBI queries, one is based on a
BEX Query of BW system sys1 and the other on a BEX Query of a second BW system sys2. Both BW
queries have the same fields and the same variable names.
In the Query Panel you can get the variable values for each query individually in the set variables screen.
So there the two queries get the right values.
But when you execute the report on the combined variable screen of the BO report you only see the values
of the first query (picture 1 - from Q4E) for variable values (e.g.
Product ID)
If you select a value, you get an error message as the value is not in
the second query (picture 2)
To sum up, situation is like this:
PRODUCT (sys1) PRODUCT (sys2)
A 1
B 2
C 3
PRODUCT – prompt window in BO
A
B
C
So values from sys2 are not there.
Select A you get error from sys2 “wrong value for the variable”.
Create a new BO report and take sys2 as first query and sys1 as second query
PRODUCT(sys2) PRODUCT(sys1)
1 A
2 B
3 C
PRODUCT – prompt window in BO
1
2
3
Select 1 you get an error from sys1 “wrong value for the variable”.
Is it possible to have the combined LOVs when refreshing?
PRODUCT – prompt window in BO
1
2
3
A
B
C
and if possible then the value when being sent to both systems sys1 & sys2 should only fetch values from the system where it finds them. From the other system it should just return no values instead of giving an error(which is now the case)
Many thanks.
KR,
Rense