Key Figures Update
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