Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

WEBI 4.1 - merge line items

Hi,

I have 2 BEx queries.

Query 1

Order Item Date1

111     10   20150101

111     20   20150303

111     30   20150602

Query 2

Order Item Date2

111     10   20150507

111     20   20150403

What I would like to achieve:

Order Item   Date1       Date2

111     10     20150101 20150507

111      20    20150303 20150403

111      30    20150602

I can merge the orderno, but that results in item referencing problems.

I tried to create 2 variables and concatenate order and item. However merging variables is a no-go area.

We use BO 4.1 support pack 5.

As said before no universe involved, both are BEx queries.

I am not able to create the concatenations in the SAP backend.

Many thanks!

replied

Have you tried merging Item as well?

Then have Date1 as =max([Query 1].[Date 1]) and Date 2 as =max([Query 2].[Date 2]) as your two date columns

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question