Projects
I have long been a fan of open source software and its ability to benefit the world. Among other things, open source software is consistent with my philosophy of “a rising tide lifts all boats”. Much of the software we use on a day-to-day basis is based on or incorporates open source software in some way. I enjoy working on projects that I can contribute back to the community and in particular if those tools benefit my fellow Hyperion colleagues.
Here they all are, grouped by what they do. Most have their code on GitHub.
Querying and clients
- Essterm: Essbase ad hoc in your terminal
- Drillbridge: Drill-through from Essbase and EPM to source data
- pbj-pbcs-client: Java client for the PBCS REST API · GitHub
- essbasepy: MaxL from Python · GitHub
- Vess: A whole Essbase server as SQL tables · GitHub
- Thriller: MDX queries through a JDBC driver · GitHub
- Camshaft: MDX from the command line, to CSV, JSON or Excel · GitHub
Outlines and admin
- Aggregate View Formula: Hand-pick ASO aggregate views
- Outline Export Parser: Read MaxL outline exports · GitHub
- Hyperion Parent Inferrer: Indented hierarchies to parent/child · GitHub
Data and loading
- Hyperpipe: SQL straight into a cube, no load rule · GitHub
- Cube Data: Generate test data for a cube · GitHub
- Column Transformer: Load-rule-style transforms for text files · GitHub
- Rejected Record Summary: Make sense of rejected load records · GitHub
Java libraries
- essbase-rest-client: Java client for the Essbase REST API
- Jolo: Text tables for the console · GitHub
- Griddly: Grids, the Collections way · GitHub
- ADS File Reader: Read dimensions exported from EPMA · GitHub
Retired
No longer maintained, and not on GitHub, at least not yet.