Merge functionality with WEBI 4.1 using BEx queries

[Former Member]

Hi,

I am using WEBI 4.1 SP5 and BW 7.3. I have two BEx queries on two Infoset..  'Query 1' has 'Request' related data while 'Query 2' has 'Material' related data. I have merge the two queries on 'Request #' and other common dimension. I have created a new variable for Material base on 'Query 2' as detail object. I have added the variable to 'Query 1' result set, but I am not getting the Material data for a given Request # which I see it in Query 2 output.

Has anyone experience similar issue with Merge feature? Is this feature only supported with queries base on Universe?

Thanks in advance for your help.

BI Developer.

[Former Member]

Hi Bharathi,

Use extended merge option in document property.

Thanks,

Shakthi Raj Natarajan