Home > Ask the SAP Experts > mySAP solutions Questions & Answers > Can multiple instances of SAP BW run multiple data mart components?
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Can multiple instances of SAP BW run multiple data mart components?

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
Is it possible to implement an SAP data warehouse and BW solution and host it on distributed database servers? I ask this question because I have concerns about response times if the data and Info Cubes are all located on a single server.

We were considering a multiple implementation of data marts -- 11 in all -- but this has flexibility issues, so we are looking at SAP BW for a solution. Ideally, we would like have all of the organizations' data on one server (24gb) and then allocate a server to each country to hold InfoCubes on which they can run their reports, etc.


>
EXPERT RESPONSE
It is possible to have multiple instances of SAP BW running multiple data mart components. This model is recommended if you have an ultra-high volume warehouse (ranging into tens of terabytes). Such a high volume EDW (Enterprise Data Warehouse) system comes with its share of challenges.

a) Separate BW license purchase
b) Very high network traffic
c) Landscape synchronization issues

These days the database engines are highly optimized at the Kernel Level. You should look at single-server installations first, along with logical and physical partitioning implemented. Multi-server data mart scenarios should only be evaluated after evaluating single-server data marts.


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
Will business intelligence and SAP BW help automate the downloading process?
Evaluating CRM, online store and Internet Sales R/3 Edition
Evalutating CRM B2B functionality
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 BI (business intelligence)
New Business Objects platform promises better integration with Oracle, Microsoft
ASUG starts Business Objects user group
The benefits of business intelligence come in saving lives for one organization
SAP links corporate performance management to supply chain
Business Objects enhances midmarket business intelligence tool
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

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