Automation of Workbook

[Former Member]

Hi BE Experts,

I have some typical requirement.

I have some workbook with different Queries in it. There is some wrap up in one sheet with formated data obtained from the results of the other queires.

Say Workbook 'A' , It has 5 pages. The first 4 pages have queries data , say Sales, Delivery, Billing and Purchaing information and the last page have the formatted data to show all these results(having formulaes). I want to automate this workbook to refresh daily and I want to place this using Save As, in a folder with todays date.

Is there any methodology to do it in BW ?

This is of high importance and I would appreciate your comments and experiences in similar requirements.

Regards,

-N-

[Former Member · Accepted solution]

Hi,

The automation is done via the Info Broadcaster. Once you have cust / sap exit variables on time to derive today's date it is straightforward. However that wont achieve the requirement you have to save it to a folder - best you can do with the Info Broadcaster is to get it to someone's mail Inbox.

Regards

Gill

[Former Member · Accepted solution]

Hi Gillian,

Thanks for your responce. Information Broadcaster doesn't fit to my requirement. My users didn't want the mail. They want it to be placed in a Project Folder so that, it is restricted from any changes.

Regards,

-N-

[Former Member · Accepted solution]

Hi Experts,

Any body can throw some light on my problem ? Any clue will be greatly aprreciated.

Regards,

-N-

[Former Member]

Hi Sonti,

I have a similar requirement in our production system.

The requirement is to execute the workbook in the bach ground and should place the ouput in application server in the excel format.

Thanks in advance.

Regards,

Bhanu