OBIEE Maintenance Mode

Setting the maintenance on makes the system readonly. This feature is of particular importance to us when you want to do maintenance activities but still allow the users to access the application. Users will not be able to save any reports and thus maintain the consistancy of the webcatalog.

You need to be able to access the Administration page from your answers login.

The maintenance mode can be toggled ON/OFF on the main OBIEE page when you login to analytics with the link http://servername:port/analytics. At the top right corner of the page click administration link, on the resulting page under Maintenance and Troubleshooting section, you will notice the link toggle Maintenance Mode. Click the link to turn ON/OFF. In a clustered environment the mode can be toggled on each node separatley.

When set ON, users will recieve a message saying the "System is in Maintenance Mode. Please Try again later". whenever any user tries to save a report.

This means that you as administrator can lock down changes to the dashboard and catalog while a release is underway, a backup is taking place, .... Usually some activity where it is ideal that no changes are being made until the operation completes.

OBIEE and Oracle INTERVAL DAY(3) TO SECOND(2)

How can I get the time difference from an INTERVAL DAY TO SECOND column?

Push the requirement back to the database if possible and we will use a 'trick' of SQL and dates to return a number result as if we had subtracted one date from the other. I'll leave the different calculations you may need to get the difference in hours etc... What I was interested in was the difference in seconds.

Assuming that the column in question is RUN_DURATION and has been defined as INTERVAL DAY(3) TO SECOND(2)

Aside/hint: We can add an interval to a date and the answer is date.

We will add the interval to a date and then subtract the date, yes I know it sounds like one of those trick mathematical quizzes that children are so fond of.

our RUN_DURATION is wrapped as follows

(SYSDATE+RUN_DURATION-SYSDATE)*86400 AS RUN_DURATION

The answer is given as the difference between two dates as standard in Oracle where 12 hours is 0.5 of a day. Multiplying the answer by 86400 gives me the answer in seconds.