Skip to Content

Automate process to control access to BO data source

Hello experts,

We have 1 of the oracle data sources used by BO 4.1 for reporting. Everyday this data source must be refreshed with new data at a specific hour.

During these data refresh hours, we want to hold off all BO reporting to just this particular data source. Today, we automate a process to disable the BO adaptive job server to gate any scheduled jobs from running until data refresh is done. However, we are not able to gate/stop the fresh-on-demand jobs to connect to just this data source.

We are seeking sound advices from the gurus for a solution to achieve this task with automation (command line/script driven), whether it's done on the BO server or on the Oracle DB server.  

Thank you in advance for your tips/thoughts.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 12, 2015 at 03:59 PM

    Everyday this data source must be refreshed with new data at a specific hour.  During these data refresh hours, ---->  OK,

    now what I didn't understand is this line---> we want to hold off all BO reporting to just this particular data source ----  did you mean you want to stop all reports refresh until the data source is updated or you want all the reports to use this data source for that moment by stopping using the existing source?

    So until I get further clarity from you, here is my say:

    If you want to have no one else use the reports, I'd say stop the Adaptive Job Server completely for the moment concerned.  All I can see as far as BusinessObjects is concerned that you must plan your refresh/schedules accordingly for concern w.r.t oracle data source.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ely Turkenitz

      Hi Ely,

      Another approach ,

      which will work if you know which report are based on the database which u want the reports should not  refresh against.

      You can specify Viewing and scheduling server group for reports in CMC, and stop the Viewing and Scheduling Server Group when you want that these report should not be scheduled/or Viewed on demand.

      If you have CMS on same Database , removing tnsnames.ora may cause BO CMS to stop.

      You can specify the Viweing server group as shown in the below image, and make sure you use the third option, "ONLY USE this SERVER ..."

      Hope this helps.

      Regards,

      RVS

      Capture.JPG (32.6 kB)
  • Jan 09, 2015 at 09:20 PM

    Moved to BI platform for faster response

    Add comment
    10|10000 characters needed characters exceeded