workbook

[former_member696913]

Hi Experts

I have requirement on multiple queries are insert into one workbook.

How to do it.

Thanks

SKBABU

Please search the forum

Edited by: Pravender on Jan 5, 2011 6:17 PM

[koleti_madhusudan]

This message was moderated.

[Former Member]

Hi,

Follow the steps below:

1. Open the first query in Bex analyzer.

2. Go to second sheet and select a cell and insert anlaysis item (second icon on the Bex Toolbar)

3. Right click and assign query to the data provider.

4. Goto next tab and insert analysis item for third query . and so on

The settings for workbook can be made in the workbook settings tab.

Regards

[Former Member]

Hi SK,

Open the workbook, on first sheet -> Add a query, then goto second sheet and insert the next query and so on go further. In case you want to include all the queries on same worksheet then either you need to know if all your queries are static in number of rows and columns so then calculate on how many you'll need for output and add up the next query after that.

Hope this helps.

Regards

Raj