Query on workbook.

[Former Member]

Is it possible to build Query on workbook?

ie: Is it possible to summarize the results of two querys and to display the result in another query.

Problem: Due to wrong definition of field the data get overflowed and results in sql error in query.

Now if i change the field definition thant its a risky process due to the data presence for field in different target.

Instead of that i have planned to built two queries with different selection and summarize the result in third query and attach the third query in webtemplate for web reporting.

Sure points for valid inputs.

Thanks in advance.

[Former Member]

Hi Armstrong,

Yes, it is possible to summarize the results of two querys and to display the result in another query by using workbook.

Create a workbook with the two queries in two seperate worksheets(sheet1 & sheet2) in the workbook.

Take a new work sheet(sheet3) for the 3rd query i.e. result query. In this worksheet you copy the result of 1st query and 2nd query and add it

or

You can write a formulia for adding these two query result.

Select the cell which you want the summiation of 1st and 2nd query to be displayed in sheet3. Type = in that cell and click the sheet1 and select the result of 1st query ( we displayed 1st query in sheet1) then type + and click sheet2 and select the result of 2nd query ( we displayed 2nd query in sheet2) then press enter. Now you can see the summiation of these two queries in that cell in sheet3.

Now attach this workbook in webtemplate for web reporting.

I hope you understand the procedure. If you have any clarifications let me know.

Regards,

Patil.

[Former Member]

Hello Patil,

Thanks for your information.

The query reults are summarized, calculated at the execution time,so i dont know how much no. of lines is going to be in the result sheet. if i simply write the formula for the lines where the result is not going to be displayed then i guess i will get #NA or 0 which willl become a wrong report after attaching to WAD.

Moreover i wont think that we can use this calculated qy-3 result in the webtemplate as it doesnt have a connection to sap system.

[Former Member]

One way to do this would be to use the Analysis Process Designer to populate a new InfoProvider with the output from the 2 queries, then write your Web report using the new InfoProvider.

BTW, I have played around with the APD in BW 3.5, but am not familiar enough with it to give you "step-by-step" directions for doing this.

Hope this helps get you started, though...

Bob

[Former Member]

Thanks for idea.

I am not comfort with "Analysis Process Designer". Its OK with your idea i will try to navigate.