Creating Indices on Allocation Manager Temporary Tables
Allocation Manager uses intermediate tables to temporarily store the results of an allocation calculation. When you perform allocations on large amounts of data, it is very important that indices are used correctly on all referenced temporary tables; this assures quality performance from the Allocation Manager. You should examine the indices on the temporary tables and ensure that they have been defined correctly, and are being used by the allocation SQL.
The intermediate tables used by Allocation Manager are:
PF_AL_CALC_T
PF_AL_DIFF_T
PF_AL_DIV_T
PF_AL_SRC01_T
PF_AL_BAS02_T
PF_AL_TOTAL_T
Due to platform limitation issues the prepackaged index is on the first 20 dimensions. Allocation Manager supports 30 dimensions. Depending on the number of dimensions you are using, modify the indices by adding the extra dimensions as keys, and rebuild the tables.