Skip to Content
author's profile photo Former Member
Former Member

Reporting on multiple reporting database across geographies from one BO clustered environmnet

Hi All

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jun 27, 2016 at 07:17 PM

    You can try with multiple option something like Security profile at universe data foundation level (Forcing users to select the connection according to their region) and Server groups (Server group for each region).

    I would suggest you to come up with different components that you want to avail in both the regions and we can recommend you accordingly.

    Thanks

    Mani

    Twitter : @meetmanie

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mani

      Thinking about it again, i think you have provided a very valuable point.

      If i create Server groups (Server group for each region) and give 'access' or 'deny' rights to user group to particular server group then i can force user groups to use particular services (like webi services) from a particular server.


      But what i am not sure is the server groups are logical groups. So if i have webi procroessing service 1 on UK server and webi procroessing service 2 on NL server and each server group has UK and NL Webi processing service 1 and 2 respectively does that mean a NL user group will always get the Webi processing service 2 as access is denied on Webi processing service 1. I am not suer about that about i certainly will try that in POC if we follow that design.

      Let me know your thoughts.

      Sanjit

  • Posted on Jun 27, 2016 at 05:36 PM

    Only possible solution is have multiple connections to Universe, one is UK and another one is Netherlands. You can have multiple universes with different connections and save them in different folders. Setup security for those user groups based on the location.

    Since CMS DB , and Filestore in UK, you will have some lag in login and retrieving the reports. But the refresh will be much faster, since DB connections pointing to the location where the User base is.

    But maintaining 2 universes will be nightmare. Whenever there is an update to the universe, you need to update the universe in other location as well.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jawahar

      Universe is not a problem as i can have two universe connecting to 2 databases. But the problem is when someone runs a report on a universe on UK database on an adhoc basis. Two things can happen:

      1) If the BO server is in NL the request will go from NL to UK and the data will be fetched from UK back to NL BO server and then the HTML page will be send back to UK . This will lead to severe latency specially if the connection between the BO server and DB server is slow as is the case in our case

      2) If we have a clustered environment with one BO server in UK and one in NL the system might not recognize a NL user group and run the NL report on the NL BO server or a UK user group and run the UK report on the NL BO server specially for adhoc reports (unless the reports are scheduled) . There is no way i can tie groups to services running on a particular server.

      Regards

      Sanjit

  • Posted on Jun 27, 2016 at 07:27 PM

    if only schedule based reporting is allowed - it'll be possible, as you can isolate/assign all schedules to server groups - make all schedules for UK people to run on UK nodes of your cluster.

    It's impossible to do so for Ad-hoc reporting (unless you create special set of reports/universes) for the UK users.

    But then you might as well have 2 environments separately.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2016 at 05:27 AM

    Hi Sanjit,

    you can have BO nodes in UK and NL but required somewhat good network because CMS will check all available services for every one or two minutes and update the repository.

    as mani mentioned, server group is the best option and you can have the app server also in UK and NL so that you easily mange the users and control.

    as you mentioned, login will take time. processing the report will not take time because your reporting database in located on the same data center but all the status/updates will go to the CMS in another region :-)

    we had a setup like this but network is good. we will use BO even one region is completely down. we did this for one of the bank. it's running very well.

    we did POC for BO cluster with Linux and widows, it's also working very well. you can not have CMS on two different OS but processing servers fine. hope this helps!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kashif

      Thanks for your reply. The web application server unfortunately sends a request to any available Web Intelligence Processing Server. This is done with a good intention of load balancing by SAP but in my very specific case it works against my requirement 😊.

      Kind Regards

      Sanjit

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.