Home > Ask the SAP Experts > mySAP solutions Questions & Answers > Will business intelligence and SAP BW help automate the downloading process?
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Will business intelligence and SAP BW help automate the downloading process?

Krishna Kumar EXPERT RESPONSE FROM: Krishna Kumar

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


SAP news, tips and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 03 November 2005
My company has implemented SAP R/3 at five plant locations. Top management in the sourcing department wants a variety of reports -- such as monthly and quarterly material spend analysis on different dimensions, spend by plant, by models, by vendors, by exports, etc. Right now we download spend data for each plant using a custom SAP report and aggregate the data. This is somewhat labor intensive.

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?


>
EXPERT RESPONSE
For part one of your question, business intelligence (BI) is definitely a solution for your needs. From the nature of your requirements, looks like you have a need for Spend Analytics. There is pre-delivered content available within SAP BW (called Business Content) for performing various spend analytics by vendor, purchase organization, marketplace, etc. Spend Analytics information can later on be fed back into the OLTP system for performing various economies of scale purchasing to optimize vendor negotiation.

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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
mySAP solutions
Error claims ship to party is not defined
User exits for changing fields
Evaluating CRM, online store and Internet Sales R/3 Edition
Evalutating CRM B2B functionality
Can multiple instances of SAP BW run multiple data mart components?
Is there an RFC or BAPI that can manage dates on production orders after release?
Reduce shipment costing with SAP or third-party solution?
We need help figuring out our SAP license
What's the best sequence for our ambitious implementation?
Can I create a document in DMS?

SAP BW (business information warehouse)
Preparing for an SAP BI interview
Job prospects after SAP BI training
An SAP BW 3.1 to BI 7.0 upgrade should not take one year
Is SAP BI knowledge advantageous to an ABAP user?
Key figures and web templates in SAP BI
Is ABAP knowledge necessary for SAP BI?
The prerequisites for SAP BI training
Using transactional and master data when creating an InfoCube
The tables/views used to populate extractors
Useful transaction codes in SAP BI
SAP BW (business information warehouse) Research

SAP MDM (Master data management)
TechEd: Kraft provides tips for a successful SAP MDM project
Preparing for an SAP BI interview
Key figures and web templates in SAP BI
Is ABAP knowledge necessary for SAP BI?
SAP, chemical firm work through MDM issues
SOA, BPM drive data modeling interest
How to install SAP BW
Data warehousing workbench in BI 7.0
SAP master data management demo and trends
How to replicate a material master from R/3 to SRM

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
BEx  (SearchSAP.com)
Business Information Warehouse  (SearchSAP.com)
Enterprise Services Architecture  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
HomeNewsTopicsBlogsTipsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2000 - 2008, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts