Query for SAP BW
I need to get an answer of one of my question. We are in the process of implementing SAP BW within our company. We have many legacy systems and SAP as well.
Our scenario is that we have more than one projects going on at different sites and every project has a different database. Every time when a new project starts a new database created. We need to get the data of these databases in SAP DASHBOARD which is depending at SAP BW.
Someone told us that we need to make a single database and send all these databases data into that single database and then use this single database for your dashboards which is based at SAP BW.
Now my main question is that SAP recommends which methodology and what is the reason for that.
If there is any authentic URL exists please share that as well.
Qazi Wasif Ali