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

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, [...]

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, [...]

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