Skip to Content
Former Member
Apr 05, 2007 at 06:31 AM

Broadcasting and creating Excelfiles


At this moment I am investigating an interface between a Sales Force Automation system in Lotus Notes and a NON-SAP datawarehouse. This datawarehouse will be replaced by SAP-BW, so a new interface has to be created.

The functionality of the current interface is:

1. Lotus Notes creates a triggerfile of customernumbers who have to be visited the next day.

2. Based on this triggerfile a set of reports per customer is run in the datawarehouse in batch,

3. the results are put in XLS-files on a fileshare with a filename of customernumber_date_time.xls

4. These XLS-files are moved to Lotus Notes, and put by an Lotus Notes-agent into documents based on the naming of the XLS-file, so they can be read in a Lotus Notes view.

Items 2 and 3 have to be replaced with SAP-BW-functionality.

My question is:

Can broadcasting play a role in this? If yes, in which way? Or are there other BW possibilities?