I’ve decided I’m going to put review of the most useful and most hot topics from the Oracle’s discussion.
OBIEE Kenobi is giving a good amount of resources for starters, including Mark Rittman’s blog. Definitely worth giving a look, if you’re new to bi solutions or obiee.
#2. Calculations using Physical Tables vs Logical Tables asked by Mark Thomspon
Kishore Guggilla and wobiee1 answered the question almost at the same time. I really liked the short and consise description of ” The Physical vs Logical has an impact as you already described:
Logical will first aggregate and then calculate. This is the case with a lot of measures just as your example sales/profit.”
This is one of the most common questions – setting up time series functions. Few experts are giving their few to what they consider to be time series in OBIEE. They also portray examples of such functions as AGO and TODATE. OBIEE has several options for implementing time , however, I recommend canonical time – it’s slightly more difficult to implement – but is more beneficial for your bi system.