RDM Table Size Concern
Hi,
We have implemented integrated RPAS environment where MFP, LP and AP are integrated through HSA.
We have RDM Dim tables for PROD holding around 1,260,000 item~colors.
The partition dimension is at group level.
We are going to implement program planning in another few months where we will be introducing more item~colors, in worse case another 1 Million item~colors.
Our concern is the measure data might become too huge - RDM shared measures as well as the domain measures size. Also the domain size will increase.
Is there any limit to how much data RDM tables can hold for optimum performance.