Merging the 2 queries

[Former Member]

Hi all,

i am having a requirement. i had 2 queries with different conditions on the same cube. i need to merge dis 2 queries n want the ouput in one excel sheet. plz help me to settle dis issue. appreciated with ***************

Thanks & Regards

priya

[Former Member]

Hi,

You can create a workbook and insert the queries in one sheet or in 2 different sheet and then link the values of these two queries into one report in the third sheet.

Assign points if useful

Regards

Venkata Devaraj !!!

[Former Member]

Hi ,

U can do this by using worbooks.

Just execute oine query , u will get the output in one sheet , in another sheet insert the data provider (the other query) , then in the final sheet merge using Excel Cell or whatevr u want to use..

And then finally save the wirbook with some name , from the next time u have to only execute the workbook once all wil be automaticaly adjusted ..

Hope it helps , assign pts if helpful..

Regards