This discussion is archived
5 Replies Latest reply: Feb 3, 2013 6:54 AM by Srini VEERAVALLI RSS

How to make OBIEE reports available during the DB tables data refresh?

sarvan Newbie
Currently Being Moderated
Experts,

We have our production ETL run for 2.5 days every month. OBIEE reports will not be available during the run. We have a requirement to make the reports available all 24 hrs 365 days. So, what we are trying is to copy all the fact/Dim tables to the new schema running in the same or different DB server and amend the connection pool to point this schema during the run. Here are my questions. Is this a workabale solution (or) is there better approach for meeting our requirement

Regards,
Sarvan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points