Format of Reporting Agent Excel Workbooks

[former_member447413]

Hi there.

Is there anyway of customizing the format of the excel workbooks that are produced via the reporting agent?

e.g. maintaining some sort of template or (ideally) being able to customize individual reports.

Thanks.

Mark

[former_member188975 · Accepted solution]

Hi Mark,

You should be able to do this by creating a workbook template. Take a look at the following links:

http://help.sap.com/saphelp_nw04/helpdata/en/33/746e393cf65c1ae10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a551ce09411d2acb90000e829fbfe/content.htm (New Workbooks when embedding)

Hope this helps...

[former_member447413 · Accepted solution]

Hi Bhanu.

Thanks - I will give it a go. Only downside with that solution is that the template has to be selected locally on each machine where the download scheduler is used.

Cheers.

Mark

[former_member188975 · Accepted solution]

Yes, you are right. Also this workbook (template) would need to be assigned to each user by way of a role.

[Former Member]

Hi Mark,

What version of BW are you on, as I am using BW 3.1 and would like to know how you produced excel workbooks from Reporting Agent.

Thanx Grant.

[former_member447413]

Hi Grant.

We are on 3.5 but in 3.1 the functionality already exists. Producing dumps of data in excel via the reporting agent is just standard functionality... i.e. just select excel in the setting.

[Former Member]

Thanx for getting back...

Realised this after I posted the question.

I've got the web template to execute and downloaded it to excel via the Download Scheduler.

Anyway to email/FTP the excel report from within Reporting Agent / Download Scheduler? (I know that this is possible using the Information Broadcastor of 3.5)

Cheers Grant.

[Former Member]

Hi Mark,

I want to execute one Query in the Background.That Query is taking lot of time. it got nearly 1000 hierarchies. They want see in single report.Could you please any guide me how can i configure for that. I know abt Exception and Printing Query in the Back ground. Could you please guide me how to configure for Executing in the Background .

Thanks in Advance.

Nagesh