Skip to Content

Flatten a BW Query

Aug 11, 2017 at 02:13 PM


avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Prakash Murugiah Aug 16, 2017 at 01:46 AM


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.

10 |10000 characters needed characters left characters exceeded