SQL Server - Infinite recursion detected

Asked By dba on 12-Oct-07 03:18 PM
I get an error when I try to process a calculated member. Infinite
recursion detected, The loop of dependancies is Gross Revenue => Gross
Revenue. Not sure how to resolve this, essentially I need to sum
payments and reversals per collector to get the gross revenue. Looks
right to me not sure what I'm doing wrong:

SUM([Collector].[Collector ID].[Collector ID],[Payment Class].
[Universal Payment Transaction].&[CR] + [Payment Class].[Universal
Payment Transaction].&[REV])




Jeje replied on 15-Oct-07 02:31 PM
you want the sum of what?

currently you sum the current measure himself... so it's an inifinite
loop...

I think you want something like:
SUM([Payment Class]. [Universal Payment Transaction].&[CR] + [Payment
Class].[Universal Payment Transaction].&[REV]
, measures.MEASURETOSUM
)