Key Figures Update

[Former Member]

Hi Friends,

i have a cube of 5 Key Figures. I am Loading data from ODS to this cube. i have time characteristics as 0FISCAL Period/Year, Posting Data, Fiscal Year in my cube.in the update rule for 2 Key Figures these Time characteistics are mapped with CREATEDON Date of ODS and for other 3 Key Figures, time Characteristics are mapped with STATISTICS date of ODS. Because of such mapping when i am loading data from ODS to cube its updating double records for each single record of ODS. In one record it update value for 2 KeyFigures and in the second records it updates the other 3 Key Figures and rest all the fields are same.

Is there any solution to update only 1 record in the cube having all the Key Figures value instead of two records.

Hope u have understood the situation

Thanks,

Nagesh.

[Former Member]

Hi nagesh,

I think your key fields are not defined properly.Plese check those once.

Regards

Prasad