Skip to Content

Multiple Queries in same workbook but in different sheets

Hi Gurus,

I am working on workbooks in Bex. I have around 15 queries. The requirement being :

Queries 1 to 10 -> Workbook1 Sheet1 . ( This is done and works fine)

Query 2 -> Workbook 1 Sheet 2.

Query 3 -> Workbook 1 Sheet 3.

Here when I insert query in sheet 2, the queries from sheet 1 disappears.

How to insert multiple queries in different sheets in the same workbook?

Points assured.

Regards,

Sunitha.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 20, 2007 at 09:00 AM

    Hi,

    open your workbook, sheet 1, select Tools->Insert Query from the bex-toolbar and following select the query 1. After that, goto sheet 2, select Tools->Insert Query.... and select query 2.....

    regards

    Siggi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Siegfried Szameitat,

      I have inserted the queries in my worksheet. My next problem being am unable to save the workbook in the template format.

      Inspite of selecting PERMANENT WORKBOOK TEMPLATE option in the

      settings the queries dont get executed in the format. The format is available only

      for the first query in Sheet1 and for the consecutive sheets the format isn't available.

      Do you have any idea regarding this?

      Regards,

      Sunitha.

  • Feb 17, 2011 at 01:28 PM

    answered

    Add comment
    10|10000 characters needed characters exceeded