Skip to Content
0
Former Member
Feb 27, 2009 at 10:14 PM

Change ODS keyfield - Extractor 0CO_OM_CCA_4

100 Views

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