Using DTS to migrate data into SQL Server, Alitum was able to create four star-schemas. Alitum used AppsMart 1.5 from AppsCo Software, to design, model and deploy CAC's four star-schema data marts. That meant we were able to build their feedback into our design early on, which proved to be a real advantage. Microsoft OLAP Services was then used to create four cubes to enable decision makers at CAC to analyze projections, domestic shipments, foreign shipments, and inventory. Using the OLAP services virtual cube capability gave CAC the ability to cross analyze their data.
Users simply open the desired report to find the latest data.
The new system is already helping the California Avocado Commission detect new kinds of challenges and opportunities. CAC plans to include additional subject matter, such as promotional and seasonal information, in the future. This will enable them to further leverage their hardware and software investments. It is also planning to make relevant reports available to handlers and growers. Viewing and analyzing their data in comparison with the rest of the market will empower them, and also help motivate them to continue reporting these valuable figures to CAC on a regular basis.