Hyperion Utilities

Aggregate View Builder
Alex has simplified the process for building custom aggregate storage views. The link takes you to his blog article which includes a web based application for generating the aggregate view file.

Jason Jones' Hyperion Utilities
Jason has actually developed a number of handy utilities so instead of linking individually you can visit his website for the latest list. His utilities include:
  • ADS File Reader
  • Cube Data (generates test data)
  • Essbasepy (python wrapper for MaxL)
  • Huma Unused Member Analyzer
  • Hyperion Parent Inferer
  • Hyperpipe (load an Essbase cube from a SQL DB without a load rule)
  • Jessub (generate MaxL scripts from templates)
  • Rejected Record Summar
  • Tieout (compare cubes with data sources)

OLAP Underground Outline Extactor
The OlapUnderground Outline Extractor is a free tool that exports Oracle Essbase outline contents into files in various formats / layouts. The original developers no longer maintain this software but it is still maintained to an extent and hosted by Applied OLAP.

OLAP Underground Advanced Security Manager
Like the Outline Extractor, this application is now maintained by Applied OLAP.  It has various security related features such as the ability to migrate security between servers, modify security settings, maintain user connections and also maintain locks. All of this can also be scripted through a command line interface.

OutlineReader is a Java package (jar) made to extract Essbase outline structure (parent-child format) and its properties (alias, formula, uda, attribute...)

MaxL "export outline" XML parser


  1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training from India . Nowadays Java has tons of job opportunities on various vertical industry.

  2. Play online casinos with fun and money fun slots Fun money, take while there.