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
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
We have two measurements we use in our shipping -- we either ship each item, or a truckload of items. We'd like to find a way to reduce the costs of ... Continue Reading