Really appreciate some advice from BO gurus on a SAP BO architecture issue.
I have a requirement where we have 2 reporting database server (one in UK and another in Netherlands).We have one SAP BO reporting system in Netherlands in the same data center as the reporting database (in Netherlands)
My client wants to use the same BO reporting environment currently in Netherlands to report from the database in UK. Unfortunately the connectivity between the datacentre in Netherlands and UK is not good. It is difficult to refresh report (specially for adhoc large report). Fortunately the user groups in NL and UK are completely independent.
Is there any architecture i can follow where i can have a clustered BO environment with one machine in Netherlands and one in UK and 'somehow' compel the NL user group to use the Netherlands BO server to run the reports from the Netherlands DB and UK user group to use the UK BO server to run the reports from the UK DB. The only problem is CMC database will be in NL so there may be some access time lag for people logging in from UK.
Appreciate if someone can share some idea for such a scenario which we can test in a POC.