Enhancing 0PM_C01 infocube.
We are working with 0PM_C01 infocube, flawless up to now, loading deltas through 0PM_OM_OPA_2 datasource (Orders’ Actual Costs). We have 30 millions of records. But users are asking for 0material characteristic to be included into that cube.
So we have checked the datasource 0PM_OM_OPA_2 and we found that it includes the field MATNR already, although not mapped to anything, as 0PM_C01 infocube does not include this 0MATERIAL object.
So we are thinking about adding a new dimension to this cube, the dimension “material”, and including the characteristic 0MATERIAL on it. After that, we will map the field MATNR of our standard datasource to the new material dimension. It seems to be easy and it is not supposed to hurt future delta loads.
But, what about the historical data?? Can we think in a remodeling process that allow us to complete the old records with this new field without thinking of deleting all, neither doing a initialization? Business day-to-day doesn’t want an initialization, unless it doesn’t mean all users block. I’ve checked if it is possible to do an early delta initialization, but it is not possible with this datasource.
I read a lot of stuff about remodeling, but related always to a characteristic that won’t modify the granularity of the enhanced dimension, but I am sure that 0material characteristic will modify this granularity and it will affect to the fact table, where is going to be more records from now on. In addition, the sample routines always refer to reading a master data to fill the new field, but in my case we want to use the same datasource that is used already for the rest of the characteristics and key figures, since it is a characteristic included in.
Could you please suggest a good strategy to face that?
Is it possible to use a Repair request load and setup tables?
Thank you very much and best regards to everybody.
Raf Boudewijns replied
Jorge Sierra Piris wrote:
But, what about the historical data?? Can we think in a remodeling process that allow us to complete the old records with this new field without thinking of deleting all, neither doing a initialization?
A remodeling process is used when you need to fill a new field with a value/formula based on data that's already available in your InfoProvider. Since you don't have 0MATERIAL in it yet, I think it's safe to say remodeling is not an option for you.
That doesn't mean you need to delete all data if you're very careful. You could work with full repair loads (if you can assure you can easily identify all historic records for which you need to add the value of 0MATERIAL). That process is (in my opinion) a whole lot more complicated than a new init/complete reload, but it could be possible...