Big feature comes to Essbase in standard PSU
Introduction Back when Essbase version 7 came out and we were introduced to ASO, Hyperion also introduced us to MDX. It was added as the calculation language for member formulas in ASO cubes but we also were able to use it as a query language against the database. As a bonus we were not limited to just ASO we could write queries against BSO databases too. Having a powerful query language similar to SQL had tremendous potential for Essbase. We could write complex scripts to pull very specific data from our cubes and even had the ability to create custom members and sets in the queries alleviating the need to modify the actual outline just to get a calculated result. Overtime the MDX query language has been improved and Oracle has done some very cool things with it behind the scenes to drive things like OBIEE. For the average power user though, MDX for Essbase had one major limitation; there was no good way to get the results of the query in a useable for...