Unable to load measure data - failed with unique constraint
Summary
Unable to load measure data - failed with unique constraintContent
Hi,
We are trying to load data in the custom measure but data is not getting loaded and failed with unique constraint.
Measure is defined with below granularity:
NAME CREATION_DATE GRANULARITY_ID LEVEL_ID MEASURE_ID LVL_NAME
XX_Percent 2020-01-22T15:30:32.000+00:00 300000026711472 1 300000026703822 Item
XX_Percent 2020-01-22T15:30:32.000+00:00 300000026711472 34240 300000026703822 MERCADO
XX_Percent 2020-01-22T15:30:32.000+00:00 300000026711472 52 300000026703822 Month
XX_Percent 2020-01-22T15:30:32.000+00:00 300000026711472 41 300000026703822 Business Unit
Process ID # 722446
Log Details:
Is Attribute Based Planning Enabled = 2
Measure ID LIST::0
CUSTOM Measure ID LIST::0,300000026703822
USERENV('LANG') US
Total_time for insert all is : .0388333333333333333333333333333333333333