Rittman Mead - Delivered Intelligence

Whilst in some ways it’s good that you can bring data from different data
sources into Oracle BI Suite Enterprise Edition, this is only of limited value
if individual fact tables and dimensions are only made up of data from a single
data source. Your sales fact table might take data from a relational Oracle
table, whilst your budgets [...]

Well, that’s finally finished now. After about two months of effort, mostly in the evenings and on train journeys to and from London, I’ve finally finished the course material for the seminar series I’m starting next week.

The normal routine I go through when doing a new presentation is to first put together the slides, to [...]

Well, that’s finally finished now. After about two months of
effort, mostly
in the evenings and on train journeys to and from London, I’ve finally
finished
the course material for the seminar
series I’m starting next week.

The normal routine I go through when doing a new presentation
is to first put
together the slides, to give the talk some structure and pull [...]

Yesterday, I wrote about the use of a table function as an alternative to a date transformation table in the calculation of YTD. Mischievously, I used filter conditions to restrict my selection to a single product and store over an April until now window. The results I captured show little difference between the three techniques [...]

David Aldridge challenged me to write about functions that return lists of dates. So here goes
In blogs past I wrote about the joys of calculating year-to-date, YTD, on sparse data sets. To my mind sparsity is a good reason to not include ytd values in slightly aggregated summaries.
But that still leaves us a few methods [...]