The Challenge

Henniges previously used Hyperion Enterprise as a consolidation tool and Hyperion Retrieve for reporting. They also used a home-grown SQL Database for all data loading, integration, and mapping activities. The company wanted a unified solution for all their financial consolidation and reporting, forecasting, and analysis - all maintainable by the same staff that maintained Hyperion Enterprise.

What OneStream Did

Henniges initially implemented OneStream XF to deliver multiple solutions to meet all their financial reporting requirements in one application. Henniges also had a need for more detailed customer and product profitability analysis and extended their implementation to address these requirements. Henniges was able to replace several disparate systems (Hyperion Enterprise, custom SQL Database, remote desktop for accessing HE, and manual Excel uploads for actuals) with a singularly integrated OneStream XF solution.

What OneStream Achieved
For the product and customer profitability project, Henniges created a new virtual “cube” within the OneStream application and leveraged its extensible dimensionality. According to Ms. Hellebuyck, “Because it’s one Application, we can share both metadata and data across the two cubes, making crosscube comparisons and reconciliations easy. We don’t even move data between the two cubes. The allocation formula simply cross-references data in the Financial Cube. In other multi-product solutions, marrying the consolidations data with the part-level analytical data would be significantly more complex.”.

Best Outcome: Deeper insight into what pieces of the business are producing (or not producing) bottom-line profits.