Horizon wise Portfolio level aggregation in MIP

[akundu51]

Friends,

Need your help in configuring the following logic in MIP, Please Suggest.

1. Suppose, there are 10 instruments in the portfolio cube. Instrument wise balances are bucketed across 22 rating grades in Horizon - 1.
2. Now, in Horizon – 2, the new business to be distributed based on the rating grade wise difference between Horizon 1 and Horizon 2 (the difference is computed at portfolio level), i.e. once the computation of Horizon 1 is completed, the complete portfolio level distribution to be kept in a temporary level and then the same to be used in horizon -2 and this continues till the maturity.

[akundu51]

Guys, any help in this regard ???