Second, downloading bill of materials (BOMs) and cleansing the data is very time and effort consuming. We have our data coming only from SAP R/3 systems. Will SAP BW will help us automate the downloading and cleaning process and also help us with adhoc querying? What do you advise?
To answer the second part of your question, I would need more information on the nature of the issue, but from the looks of it, MDM (Master Data Management) seems to be a solution. I would definitely evaluate the solution in greater depth before taking the plunge, because "cleansing" data may not just be a systematic solution. Sometimes, it takes labor intensive due diligence. Also, if the BOM mismatch is because of lack of design integrity, I would investigate PLM (Product Lifecycle Management). Also, PLM comes with integration into third-party CAD tools that may make engineering integration easier.
Dig Deeper on SAP Business Warehouse
Related Q&A from Krishna Kumar
An SAP user did everything right, but an error message is saying otherwise. Krishna Kumar weighs in with some possible reasons for the problem. Continue Reading
Although greyed out items usually can't be changed in sales orders, it is possible to manipulate user exits that can enable you to change certain ... Continue Reading