UAC had over 140 standalone shops with each operating with a standalone ERP system. Now, these data can be consolidated efficiently with near-zero manual intervention.
- There was 2-3 months lag in financial reporting.
- Analysis was done using different and often huge excel sheet with un-versioned macros.
- Reports were done only at the general ledger level. Manual Data consolidation was done for financial GL data only
What we did
- Previous month financial report is out 5 days into the new month
- Data analysis can now be done online at business speed by business users accessing shared MOLAP cubes
- Product sales analysis, stock positions, reporting, stock transactions reporting can now be done by end users by browsing MOLAP cubes