Multiple BI Query Results into one Table

[Former Member]

Hi All

Can I embed Multiple queries into one table using VC?

I have data in different BI sources(Info Areas) like sales and distribution,Shipments etc. Can I write any universal query to retrive data from multiple sources?(If any???)

[Former Member · Accepted solution]

Have a look at former threads discussing this.

The best way is to do that already on the backend side (e.g. through a MultiCube)

[Former Member · Accepted solution]

Thanks for reply .I will try with Multi cube option. I tried with COMBINE operator in VC. I am able to see that coloums are combined but only one row is displayed. Any idea why its happening like that?

Thanks

[Former Member]

I started a WIKI page to this topic:

https://wiki.sdn.sap.com/wiki/display/VC/Combiningtwotables,BAPIsor+queries

[Former Member]

UNION component in VC should help you. You can locate it under Compose >

[Former Member]

Hi Jan Pasha,

My model contains two BW queries which uses UNION and sent result to one table.

I tried using UNION also but when I use it I am able to see no records to select in result table.

I donot have any coloums in common. Is it pre-requisite for using UNION?