Home > Ask the SAP software/management 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, Years 2005-2007 EXPERT RESPONSE FROM: Krishna Kumar, Years 2005-2007

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?


>
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 business information warehouse
Four things SAP must consider before a Teradata acquisition
SAP BW or third-party data warehouses a dilemma for SAP customers
Should we install SAP BW on the same server running SAP R/3 4.7?
SAP: Don't rush from SAP BEx tools to SAP BusinessObjects
SAP shores up SAP NetWeaver BW with Teradata
Choosing an SAP BI/BW database for InfoCube data
Using Infoset to join, move DSO analysis to InfoCube
Selecting InfoCubes in SAP BI/BW Business Content
SAP BI roadmap one year later: How's Business Objects working out for SAP BI customers?
How to limit employee access to reports using roles in SAP NetWeaver
SAP business information warehouse Research

SAP MDM software
Quiz: SAP master data management (MDM)
For MDM, start by getting to know your enterprise data
Creating an enterprise MDM initiative in an SAP environment
Using SAP NetWeaver MDM with CRM, SCM and NetWeaver BI
The importance of master data management following mergers and acquisitions
Enterprise MDM: SAP MDM for reducing data silos and duplicate records
Designing your SAP NetWeaver master data management strategy
Successful MDM strategy starts with finding broken processes, not technology
TechEd: Kraft provides tips for a successful SAP MDM project
SAP, chemical firm work through MDM issues

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
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, 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