I am currently at a project where we have to take the decision whether to set up a new BW 7.0 or use an existing one. The existing one already contains a BW solution, used for financial reporting and sales reporting based on SAP ECC 5.0. Due to initial costs and maintenance costs of setting up a separate BW we are leaning towards the option of implementing the new BW solution in the same environment as the existing one. The new solution will be based on SAP ECC 6.0. That means a different source system.
The idea is to have separate data flows, i.e. use separate DSOs, InfoCubes etc. Reporting will be based on either of the data flows, not both at the same time. If we need to use the same infoobject we have seen that u201Csource systemu201D is mostly a key of the MD tables, or possibly some other identifier already in place as a key field.
Has anybody done this before? What are the difficulties you can run into and things to keep in mind? Are you advising against this solution or do you think it is feasible. Any input is appreciated!