Rittman Mead - Delivered Intelligence

Just a quick note to remind any who’s not yet registered, that the cut-off date for registering for ODTUG KScope’11 with the $250 discount is June 9th, just two days away. If you’re planning on coming and want to save as much money as possible, register now whilst the discount still stands. If your interest [...]

In a couple of weeks time it’s the OUG Conference Series EPM & Hyperion 2011 Conference in the UK (now there’s a mouthful), and along with such Hyperion luminaries and Oracle ACE Directors as Edward Roske and Eric Helmer, I’m presenting a session entitled “OBIEE 11g for Hyperion Customers / Developers – Are We There [...]

I was actually compiling all my findings of the last 4 posts as a summary post but then realized i haven’t actually covered another important part of the Essbase Connectivity i.e. Essbase Security. In today’s post let’s look at how Essbase Security is handled in BI EE 11g. I will follow this one with the [...]

In the last 3 posts we saw how BI EE generates the MDX and what major factors influence the MDX generated. As a recap, there are 4 main things that we noticed. 1. BI EE generates the most optimal MDX as long as we have all the attribute or Hierarchical columns in the Row-Edge of [...]

Continuing along with our Essbase series, today lets look at how the various Pivoting operations that are done at the BI EE layer affect the MDX generated. We noticed that whenever we brought in an attribute column from the row-edge to the column edge, the MDX generated by BI EE had become completely in-efficient. Let’s [...]