UKOUG Wrap-Up

December 10th, 2007 by Mark Rittman

Just to finish off the postings from last week’s UKOUG Conference, I’ve uploaded the three presentations that I gave during the week, which can now be accessed using these links:

Something else that I mentioned during a couple of the talks last week was an offer we’re currently running in the UK and Ireland until the end of next January. For a limited period only, we’re offering free workshops and one-day reviews for customers looking to get more out of their Oracle BI investment, perhaps plan a new project, work out how to migrate from Discoverer to Oracle BI EE or just put in place a roadmap for their BI work over the next twelve months. If you’re interested, drop us a line and we’ll get in touch, and we’ll see if we can help.

Other than that, now the conference season is over it’s case of wrapping up on some training and consulting work over the next week or so, and then getting set for the Christmas break. In the meantime, I’ve got some good postings lined up on integrating Oracle OLAP 11g with OBIEE and with ApEx, so until then, stay tuned.

Posted in Rittman Mead, User Groups & Conferences |

Comments

  1. Scott Powell Says:

    December 11th, 2007 at 6:03 pm

    Mark, just curious if you “integrating OLAP 11g with OBI EE” piece is going to speak to using the OLAP functionality to supply RAA / RAM type functionality - where you could store the detailed data in relational tables, and summary data in OLAP. This is functionality that was “lost” with the integration of OLAP into the database engine (technically it was feasible, but it was VERY tough to get this working in the “real world”).

    I’ve been thinking about creating such a doc for a while, to the point that I have some samples, etc. It’s not (at all) polished yet, but I hoped to finish it up in the next few weeks.

    Thx,
    Scott

  2. Mark Rittman Says:

    December 11th, 2007 at 6:31 pm

    Scott,

    That’s a very good subject to cover. It should be fairly simple to do - either you can map views over the AW onto the logical table sources in OBIEE, so that queries against higher levels of aggregation get sent to the AW, or you could just use the MV / query rewrite feature in Oracle OLAP 11g, where the query tool goes against the detail level relational tables and then has its queries rewritten against the Cube Organized Materialized View (which points to the AW) when aggregations are requested.

    The first option would be trickier to set up (but would work with 10g as well as 11g), whereas the second option would be a piece of cake but would only work with 11g. I’ll see what I can do.

    regards

    Mark

  3. Scott Powell Says:

    December 11th, 2007 at 8:27 pm

    Great - I’ll continue plugging along with this as well (although I don’t have much “free time” lately….) I’m very curious to contrast the level of effort of using the 11g query rewrite vs. setting up stuff manually in OBI EE and letting it do the mapping for where to get the data.

    Thanks!
    Scott