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.
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.
Dig deeper on SAP business warehouse
Related Q&A from Krishna Kumar, Years 2005-2007
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
Wondering how business intelligence and SAP BW can help automate the downloading process and help with SAP reporting and querying? Krishna Kumar, ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.