Skip to Content
author's profile photo Former Member
Former Member

Can you export two dataproviders to excel?

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 04:16 PM

    You can do it this by using workbooks.

    Greets,

    Jeroen

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 10:03 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2004 at 05:47 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2004 at 02:52 PM

    Hi Shep,

    maybe this is a solution for your problem, too.

    Webreporting - more than one DataProvider - Switch with Command URL

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 28, 2004 at 02:08 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.