A Vertical Edge Case Study
Large Nationwide Optical Company
Engages Essbase Cloud
Essbase Cloud Implementation
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.
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.
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:
The Solution Products: