Oracle BI 11g: I Don't Like Mondays
To be honest, I like Mondays. And it's Thursday. But it made such a catchy title ;-) This article will show you how to hide Oracle BI 11g Presentation Layer objects on Mondays, hence the title. Introduced in OBI 11.1.1.6.2 (or so), we can define a conditional expression to control whether a presentation layer object (Subject Area, Presentation Table, Presentation Column) should be visible to the end user or hidden. The property is called Hide object if . As per the documentation , we can use the field in three ways. Enter a constant : 0 (zero) will display the object. Any non-zero value will hide the object. Use a variable : Initialize a (session) variable and use it in the expression. Again, if the variable value is 0 (zero), the object will be visible, otherwise it will be hidden. Provide a comparison : You can use a limited set of functions and operators to evaluate conditions. For example, the following expression will be 'true' (or non-zero) when the current day is a M...