Is there a way to dynamically display a different style on the logon screen and dashboards based on a condition in the warehouse? For example, if our load is running long, can we change the logon screen to display a graphic and text that states the load is not complete. Apply the same wording to the dashboards.
What is the best practice employed for notifying users that BI is ready or not ready for use?
You need to use JSP code in login page by customizing it.
The JSP code should read the status from W_ETL_RUN_S table column STATUS.
You may go for beans or all code can embed in the existing BI login screen.
If helps pls mark
BTW: whats the BI version?
Edited by: Srini VEERAVALLI on Jan 16, 2013 10:55 AM
Ahhh... 11g ;) I would say a little bit hard the way I was mentioning.
Since 11g uses .html page (FMW\Oracle_BI1\bifoundation\web\msgdb\pages\common\signin.html) unlike 10g. in 10g its .jsp/.asp page!
If possible can try this during user login try to validate the table column W_ETL_RUN_S.STATUS with current date using init block, if the status is not quals to completed then try to set a custom group/role and and land him with a new dashboard based on assigned role with load status, if the status is completed then use wont fall under your custom group/role.
That if you'll assign dynamically SKIN system variable?
1) create new 'skin' for incorrect ETL situations - [url http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/customizing_obiee11g/customizing_obiee11g.htm#t1]http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1113/customizing_obiee11g/customizing_obiee11g.htm#t1
2) create init block that will be assign 'error skin' name to user's SKIN session variable after logging.