Skip to Content
avatar image
Former Member

Flatten a BW Query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 16, 2017 at 01:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded