Recursive evaluation error
You run a report and encounter the following
error.
PCA-ERR-0057 Recursive evaluation has exceeded limit. Calculated member trace: COG_OQP_USR_Aggregate(Retailer Type):
COG_OQP_INT_m2: COG_OQP_INT_m1: COG_OQP_USR_Aggregate(Retailer Type): COG_OQP_INT_m2: COG_OQP_INT_m1:
COG_OQP_USR_Aggregate(Retailer Type): COG_OQP_INT_m2: COG_OQP_INT_m1: COG_OQP_USR_Aggregate(Retailer Type):
COG_OQP_INT_m2: COG_OQP_INT_m1
You may encounter this error when two or more data items form a recursive evaluation. For example, in this error, the calculation of Aggregate(Retailer Type) is dependent on a column expression while at the same time the column expression is dependent on Aggregate(Retailer Type). Therefore, the cyclic relationship cannot be resolved.
To avoid this problem, ensure that calculations do not have cyclic relationships.