siebel

Inspired by a nice instance of the Oracle BI 11g Build Repositories class I delivered last week as an LVC, I decided to share a little trick with you. What if we could verify the name of the logical table source in Answers (aka "Analysis Editor")? For example, when you create multiple table source for aggregates or partitioned data, it is important to verify your implementation. I found the following procedure to be quite helpful with that. Create a new logical column that displays the name of the logical table source. Within your logical dimension or fact, create a new logical column and map it (physically) in each table source. As the expression use a string identifying the logical table source. Just as in the screenshot below. Click to enlarge. In the above example I specified 'LTS2 F2 Revenue Aggregate' (the exact name of the LTS) as the constant value for the new column. This specific LTS is mapped to an aggregate fact table at the quarter level. In the other l...

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...

In our "blast from the past" series, I am reposting today an article which I wrote 5 years ago . With version 11g not to be released for one more year, the article focuses on strategies how to add more dynamics to the physical layer of a BI repository. Please enjoy *** During a BI project there are numerous opportunities to go down the stony road and establish redundancies where you do not really want them. When I am in a provocative mood (which I am not very often, I assure you), I use to ask "Do you want a 'B' project or a 'B I ' project?". There are so many pitfalls waiting for us to stumble into and reveal our bad (or sometimes even non-existent) design. There are many triggers for this post, as there are many fine people blogging about OBI EE ( here and here to mention just two of them, keep up the good work!) and I would also like to thank the many people who contact me with questions regarding OBI EE design and architecture. Today I would li...