cancel
Showing results for 
Search instead for 
Did you mean: 

Flatten a BW Query

Former Member
0 Kudos

I have a BW query that has Sender Order number and Receiver Order number.

When i pass sender Order number to the BW query , i get receiver order number. There can be multiple level of receiver order number.

For ex: Sender A -> Receiver B -> Receiver C -> Receiver D etc(Upto 8 level)

To acheive this we are currently running the BW query manually by passing the receiver value in the variable for sender.

Is there a way, we can have a single BW query that retrives all the record

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Not sure what you are asking. But if you want your outputs to display all values, don't enter any values in the Variable prompt or remove the variable.