This content has been marked as final. Show 5 replies
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.