Hi,
Can anyone help me please with the following:

I am trying to create a Calculated member 'Actual Cost'
for my cube.
My cube has 3 dimensions and 4 measures.
Time dimension has 4 levels. The first level 'Year' has
following values
1997
1998
1999
2000

I am using following formula.

iif(([measures].[Labor Cost] > 70)
and ([Product].[PART-USED] <> null),
-- then
sum([time].allmembers, [Labor Cost])/
sum([time].allmembers, [Part Cost]), null)

In my cube I get error for the values of calculated
member 'Actual Cost'. The error is

'unable to display cell properties
Infinite recursion detected during execution of
calculated member actual cost
An error occured during attempt to get a cell value.'


I also tried using following but get the same error

SUM([Time].[1997]: [Time].CurrentMember


Thanks

Steve

You might try replacing Product.[Part Used] by a tuple such as:

(Product.[Part Used],Measures.[Some Measure])

Your current formula tells AS to look for (Product.[Part Used],measures.currentmember).
Currentmemember is [Actual Cost] and this causes the infinite recursion.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html