Export WebTemplate to a file with data & graphs

[Former Member]

Hi BW Gurus,

Is there a way to export web template's data and charts into a single file.

I did try the enhance menu->export. It only copies/exports data not charts.

Any ideas,

Thanks in advance,

GSM

[GFV · Accepted solution]

Hi GSM,

did you try with Reporting Agent and Download Scheduler functionalities?

With Rep Agent you execute the Web Application in a background job and with DownLoad Scheduler (Start / Programs / Business Explorer / Download Scheduler) you can get precalculated Web Templates in you PC.

Hope it helps (and if so remember reward points ...)

GFV

[Former Member · Accepted solution]

Hi,

Arun & Gianfranco Vallese Thanks for the reply.

Arun, the method you have said before 3.0B release. Because in earlier versions, SAP didn't provide any download capability. After 30B SAP provides through enhanced menu the download

capability.

Gianfranco Vallese, I did tried your option. We have a web template with a tab object.

In that we have 9 tabs. Each tab has tables, filters & graphs. Reporting agent couldn't generate the template/html with all the tabs.

It only showed the first tab.

Our users wanted as, On the web report they need a button and on click of button both data and graphs should be exported to a file.

Any ideas on this ?

Atleast can we export both graphs & data if all the objects are in single template with no tabs ??

I greatly appreciate any input on this,

Thanks in advance,

GSM.

[Former Member]

Hi GSM,

From my understanding the excel download is only for the Data providers.The only way to download both data and graph in your report is to use the CTRLA and CTRLC mechanism used by the document given below,

https://websmp103.sap-ag.de/~sapdownload/011000358700002763112003E/HowToDownlWebQuerytoExcel.pdf

I have enhanced the code really better to suit my need in 3.5 and preserve whatever i have in my page.

For better understanding of Excel automation with OLE use the link below,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproWorksheet.asp

The above link provides you with Objects, Methods and attributes available for Excel automation.

Thank you

Arun

[Former Member]

Hi GSM,

If you are satisfied with the Export to Excel functionality in Context Menu then use this code in your web template to have it as a Hyperlink to Download Excel,

In the DATA_PROVIDER parameter provide your data provider name correctly which is DP in this case.

<a href="<SAP_BW_URL CMD='EXPORT' FORMAT='XLS' DATA_PROVIDER='DP'>">

<img src="Mime/BEx/Icons/S_X_XLS.gif" border="0" alt="<SAP_BW_TEXT program="SAPLRRSV" key="T77"> <SAP_BW_TEXT program="SAPLRRSV" key="T72">">

</a>

Thank you

Arun

[Former Member]

Arun,

Thanks for your reply. With the code it only exports data not the graphs on the webtemplate.

When we do export we need both data & charts in single xls file.

You don't need to put that code that you have sent. As after 2.1c and from 3.0A onwards we can download to excel using enhanced menu. If you click on the column of any table, you can choose the option to export to xl.

But if you have any ideas in exporting graphs too pl. let me know. One thing we can do is save the images and paste them back into xl. But wanted in one click as user requirement.

Thanks,

GSM.

[Former Member]

Hi,

Please see the link to download web template to Excel,

https://websmp103.sap-ag.de/~sapdownload/011000358700002763112003E/HowToDownlWebQuerytoExcel.pdf

It will exactly copy whats on the page.

Thank you

Arun