Insert queries in workbook

[Former Member]

Hello!

I need to include 5 queries in a workbook. We're in BI 7.0. I read the forum and found the following:

Execute Query 1.

Save Workbook ( Using BEx Tool bar )

Open Sheet 2

For the second query :

Go to Design Mode first ( Toolbar options - Blue coloured Letter A underlined in Red ).

Insert Analysis Grid - to insert query - Select ur Data Provider /Query

Comeout of Design Mode

Save Workbook

However, I'm not sure how to "Open Sheet 2". Can someone please tell me how to open a new sheet in Analyzer? I'm opening new excel worksheet. If I open a new query, it opens another window.

Thanks in advance for your help!

[Former Member · Accepted solution]

Sheet 2 refer to the 2nd worksheet in excel

If you look at the bottom of the excel file you will see sheet 1, sheet 2 and sheet 3.

Your 1st query will be in sheet 1.

Now you want to insert another query in a new sheet then go to sheet 2 and follow the same procedure

[Former Member · Accepted solution]

Thanks Sam!