Can you export two dataproviders to excel?

[Former Member]

We have a web template with two tables, both run against different data providers. Is there anyway to export both to a single excel spreadsheet? I can get one dataprovider to export but am having difficulty adding a second.

Any help will be appreciated.

Cheers

Shep.

[Former Member]

When you right-mouse-click in any blank area of a webpage and select "Export to Microsoft Excel" from the context menu you arrive to the "New Web Query" screen where you can select all the providers you want to import to Excel. Probably you could do it this way.

[Former Member]

Hi Shep,

maybe this is a solution for your problem, too.

I have tested some ideas, too, but it does not work:

Multi Dataproviders:

<SAP_BW_URL DATA_PROVIDER='*' CMD='EXPORT' FORMAT='XLS' MULTI='X'>

Command sequence:

<SAP_BW_URL DATA_PROVIDER='DATAPROVIDER_1' CMD='EXPORT' FORMAT='XLS' CMD_1='&DATA_PROVIDER=DATAPROVIDER_2&CMD=EXPORT&FORMAT=XLS'>

So you need a JavaScript to export each dataprovider to excel in batch. I do not think, you are able to export two dataproviders to one excelsheet...

rgds Jens

[Former Member]

Hi all,

i think he only wants to export all DP!

I would play a little bit with JavaScript.

There should be a way!

Regards,

M. Erbil

[Former Member]

Hi Neal,

The assumption is that when you loaded SAP GUI, one of the programs you loaded is call sapbex.xla

When you launch sapbex.xla, Excel opens (if Excel is not already open) and you will see a new toolbar named Business Explorer.

Select the "Tools" icon and on the sub-menu select "Insert query". Navigate to the correct info provider ... or, more easy use the Find icon, to locate the first query. Now go to another worksheet and repeat for Insert query for the second query.

You now have both queries embedded in the workbook. You can save this to the BW server using the Save icon on the Business Explorer toolbar. Or, you can save the workbook to your personal drive or a LAN drive using the Excel toolbar or menu bar or shortcut keys.

You can automate the heck out of these two queries using Visual Basic and the sapbex.xla API functions.

Enjoy!

- Pete

[Former Member]

Neal,

You can do that also on the same worksheet. Just pay attention that you put your cursor where there is place enough for the query.

Kind regards,

J

[Former Member]

Pete/J,

I apologise if I wasn't clear in my initial message, we aren't using Bex but the web. We have already created a web template with two tables within it and have a button to export the data to Excel. This button will only transfer one dataprovider but not the second...

Cheers

Shep.

Message was edited by: Neal Sheppard

[Former Member]

You can do it this by using workbooks.

Greets,

Jeroen

[Former Member]

How???