how to combine two queries in one EXCEL

[Former Member]

hi i got one requirement

i got one excel sheet from user which contains two report s(hoe we know whether it is worknook or not) of 2011 data and now user wants 2012 data .now i icluded jan 2012 to dec 2012 in two reports and sent to user.But user is asking these two reports want to see in one sheet.

so how can i proceed: if i go for work book how can i include these two reports in workbook and here my doubt is if i create a workbook based on these two querie which name i have to give user.Please help me out on the same.

Regards,

Madhu.

[anindya_bose]

Hi Madhu

Run one query. Click on a empty space in the excel

From the BEx Design Toolbar -

---

>Insert Analysis Grid -

---

> Right click on the Design Item

Edit the DataProvider.....You can ran same or different query with selection.

Save the result

Check this link for detail....I am also searching for something with screenshot

Regards

Anindya

Edited by: Anindya Bose on Feb 14, 2012 3:04 AM

[Former Member]

Not necessary for 2 reports. Drag & drop 0CALMONTH restriction across the columns. This must solve the issue. Thanks!

[Former Member]

Arun thanks for ur response already two queries are there and those two are restricted based on period varible from 2011jan to dec 2011 and i changed period values to 2912 as per user request nd ent two reports separatly.Now user wants these two reports in one sheet.So can u explain how can i proceed.

Regards,

Madhu.

[Former Member]

Try editing the query to accomodate 2 years data in one view. i.e 0CALYEAR restriction with offsets like (Y),(Y-1) & 0CALMONTH variable must be along the rows. Not all requirements can be met. If you cannot accomodate all the rows in one report, try to use WAD. Have you tried using 2 views of the query? Didn't work for me! Anyways, just let me know if this helps. Or, if your requirement is very urgent, create 2 queries (one with Year & other with Year-1 restriction) & use them in 1 Workbook as 2 dataprovider elements. Since the Year Variable would be the same for both these queries (This is important, else you get 2 input boxes), you can view 2 queries in the o/p.

Edited by: Arun Bala G on Feb 13, 2012 10:47 PM