Hello,

I am getting an error when tying to get the total sum of a measure (Mondrian Error:Number of iterations exceeded limit of 5.000.000)
I googled this error and there was:

mondrian.rolap.IterationLimit: the maximum number of iterations allowed when evaluating an aggregate --> what is meant with "iterations" here?

mondrian.result.limit: limits the maximum size of a result set --> does "result set" = "rows number"? because my report does not have 5000000 rows!! it has around 40K rows!!

can anyone plz shortly explain the terms? and what is going in the background?

thanks in advanced