EPM RADIANCE

Hyperion Planning

  • EPM GROOVY- Performing MDX Calculations with Custom Groovy Scripts In ASO Cubes

    ·

    Raja Stalvin

    I’ve been wanting to check out the new MDX custom calculation capability, which allows us to write MDX calculations directly in ASO cubes. Although the Groovy documentation only provides an example of a constant value assignment, it is possible to write more complex MDX calculations. Before constructing the MDX formula, there are a few factors to keep in mind. Writing Inventory Calculation MDX Interdependent values are heavily used in inventory calculations. This may be accomplished in BSO by forcing the calc to run in Cell mode (@CalcMode(Cell)). Let’s look at how we can use Groovy to convert the BSO calculation below into MDX code. Setting up the POV Pov, Source RegionPov, Source Region, and Script are the three mandatory fields to be specified for any MDX calculations written in ASO cubes with the CustomCalcParameters class. As usual, crossjoin is used to fix multiple dimension members in the POV. Since we have Groovy, I…

    Read More

  • EPM GROOVY – A Guide to Member UDA Updates using Business Rules

    ·

    Raja Stalvin

    The Groovy API provides a privileged function to update metadata properties using business rules. Since it’s a privileged function, only administrators are allowed to execute the same. Of late, I have been using the function to rename the members, change the parents, etc. This helps in many ways, as UDAs get a little better since…

    Read More

  • EPM GROOVY – Top Down Planning in ASO Cubes

    ·

    Raja Stalvin

    Although input at higher level intersections in ASO is not possible, the combination of groovy and EPM APIs helps us to achieve the same. Let us make use of instant aggregation in ASO along with groovy grids. Here is the link to the article I published on LinkedIn.- Click Here for full post.

    Read More