A Vertical Edge Case Study

Large Nationwide Optical Company
Engages Essbase Cloud

Essbase Cloud Implementation

Vertical:
Retail

The Client:
Our client has grown from a single location to 50 locations nationwide in less than 10 short years. They also rank 20th on Vision Monday’s Top 50 U.S. Optical Retailers and are positioned as one of the nation’s fastest growing optical retailers with strategic plans to double in size over the next 18 months.

The Challenge:
Our client needed a financial solution using Essbase Cloud for Balance Sheets and Income Statements for consolidation and close (monthly and yearly). Additionally, they required a data load to be automated so that it could efficiently migrate data from the on-premise application intake to the Essbase Cloud.

The Solution:
Our team built an Essbase Cube in the cloud to store and format the data and created a data load solution using CLI to automatically populate the cube in the cloud.

The Success Factors:
• Created Financial Cube in Essbase Cloud
• Migrated Data to Cube
• Cube used for day to day operation
• Quicker data retrieval and ad hoc reporting
• Automated Data load by connecting to their GL data source with an SQL connection
• Comparison of historic versus actual data

Company Annual Revenue:
$100 Million

The Solution Products:
Essbase Cloud