Hi
We are having ODS ZCCA_O53(Statistical Key Figures for Cost Center Accounting) loading to cube ZCCA_C53(CO-OM-CCA: Statistical Key Figures)
Data is loaded from 0CO_OM_CCA_4 extractor to ODS (Full update) - > Cube (Delta Update) ???.
ODS key fields -
Request ID,Record Number,Data Package ID ,Fiscal year / period ,Fiscal year variant
Data fields..-
Unit of measure,Cost Center ,Controlling area ,Value Type for Reporting ,Statistical key figure ,Quantity ,Stock quantity
Cube fields - Cost Center, Controlling area, Source Indicator, Version, Value Type, Statistical key figure
Key figure u2013 Quantity, Stock quantity
Requirement
Now we want to change designing by replacing key fields with other suitable key fields since by keeping current key field(Request IDu2026..) we had some issues in reloading data (Duplicating in some cases).
This Modeling is done by someone else and has no idea why they used above key fields in ODS.
My questions are
1.) Which field can we take as keyfields for delta? Extractor 0CO_OM_CCA_4 only supports full load.
With the current data I am not able to find any Key field which can have unique combination of data other than Record no.
2.) Change in design needs to be done only on ODS level, they do not want to disturb current cube data as it is attached to multicube, is it possible?
3.) What should be the approach?
Thanks,
AB