How often should I run the Investment Allocation Job? I need real time access to actuals and ETC at the investment level.
The Investment Allocation job and the investment list page is sometimes thought of as a real time reporting solution for investment actuals and ETC. The investment allocation job is better suited for daily reporting as the job aggregates data from various tables for each investment.
This job is very database intensive because it updates every active investment in the system. As a result, it should not be run frequently. Many customers run the job only once per day.
The investment list page is also suited better as a navigation point and should be limited in the number of fields added to it, as it is an entry point into the investment properties for all users.
If a XOG write action is perform for updating an existing project, the action triggers slicing and the execution of the Investment Allocation job for the specific projects so that the project manager is able to immediately see all updated data on the projects updated from that action without having to manually execute the job for all investments.
For immediate access to Actuals and ETC at the project level, a custom portlet would be more efficient and could achieve real-time results as long as the portlet is focused on those items and does not join in too much other data. Consult your DBA for optimal query design or contact CA Services if you need help building your own custom portlets and reporting solutions.
* NOTE: * If the 'Investment Allocation' job is executed in between incremental runs of the Rate Matrix Extraction, the Incremental Option will effectively behave in the same manner as a full execution because the 'Investment Allocation' job will update all projects. The 'Investment Allocation' job should be marked incompatible with the 'Rate Matrix Extraction' job. Also, the job slices some data therefore, it should also be marked incompatible with 'Time Slicing' job. See additional articles for more information.
Reference TEC525155 : What is the Investment Allocation job for?
Reference TEC510351 : The Investment Allocation Job and the Time Slicing Job should be incompatible
Reference TEC551863 : How Should I Use The New Incremental Only Option For The Rate Matrix Extraction Job?
Reference TEC528729 : Configuring and Scheduling some of the main jobs