Solution
Oracle's NetSuite Free Form application (newly available as of September 2024) was implemented to meet our client’s needs. The solution included two Essbase cubes, one for monthly financial reporting and another for daily production reporting. The financial cube was designed to handle over 800,000 metadata members including individual loans, loan officers, and job titles while maintaining high performance. The daily cube tracked additional statical data across specific calendar days at the loan level enabling precise reporting without relying on split dimensions like period and year.