EM stands for Event Management and BW stands for Business Warehouse in SAP. Both have different features and uses. But sometimes as you all know the human mind a house of unique ideas want to integrate both the SAP modules. So, for this integration one should follow the following procedure.
First of all you have to start the Data Sources queue from BW (Business Warehouse) system i.e. info Package –Init without data but due to this you would not be able to send any kind of historical data via the initial upload report. Beside this you can integrate EM (Event Management)-BW by updating the Data Sources using transaction /SAPTRX/BWIU, The drawback behind this that you would not be able to update Data Sources whenever you create or update new EH. For this you have to set the collection of laws and rules. Now the rule BW _ UPLOAD must be integrated to your collection of laws and rules. The Value X to be set as the specification for the activity for delta Upload. Once the delta queue is initialized with or without data and with the right settings to the set of collection of laws and rules the BW-upload can we worked automatically.
However you can load data of excel or flat files in to BW info cubes [fact tables] as well as master data tables, for this you have to select the files within the BW”infopackages”,Infopackages are BW loading mechanisms that focused on the ETL which means “extraction transformation and loading” processes a BW data warehouse. Info packages have a monitors associated with it that are catered for error handling and tolerance rules, and to select data with priority for load deletion ,transformation rules, record count, load monitoring etc.