Solves not running as quick as they used to? Running out of disk storage? Unable to complete a backup of the database let alone regular rebuilds?
Performance can be hard to get right in OFA, the size of your database depends more on the nature of your hierarchies and the sparsity of data than the seed data sizes. Significant changes can occur with a few years or even periods of data building up. Sparsity management (mainly down to composite design) makes a huge difference difference, we have seen databases reduced from 100GBs or more to just a few GBs with performance increasing in line.
In addition to correcting the physical database, it may be that logical changes are required, or can be delivered once the physical design is corrected, and these can again deliver big performance gains. Combining smaller cubes reduces batch times and importantly reduces adminstrative complexity.
Specific problems with interfacing OFA to the GL can be addressed too. Long load times can be reduced by pre-processing balance files to remove redundant records, loading in to a simple interface area and managing separate aggregation areas or even replacing the GL file load with a direct extract can yield huge performance gains.
There is a limited amount of Express environment tuning which can be undertaken but the effects are relatively small.
If all else fails to deliver the required gains we can assist with tuning the hardware platform.
We can provide fixed price performance assessments and quotations if required.
The batch administration facilities in OFA are fairly rudimentary. We can assist with providing a framework for batch scheduling, controlled from unix cron, the Oracle Concurrent Manager, third party tools or a mixture of methods.
Regular monitoring and housekeeping are essential to keep your OFA system in good order. We can provide administration scripts and procedures to help you avoid most serious administrative headaches.
Are your backups in order? Can you recover from a disasterous hardware failure or other crisis?
We can help you plan, implement and test a disaster recovery strategy.
We can help with upgrades of OFA versions, hardware platforms or system functionality.