Hi,

I have migrated a cube from 2000 to SSAS 2005. The cube contains many calculated members and cells.

Unfortunately the calculated cells do not work in SSAS 2005. Here is a code example:

CREATE CELL CALCULATION
CURRENTCUBE.[P1965 YTD]
FOR '({[Measures].[Act YTD]},{[P1].[Report L6].&[00490965]})'

AS ( [P1].[P1965-1] , [Measures].[Act YTD] )
+
( [P1].[P1965-2] , [Measures].[Act LY WY] ),

SOLVE_ORDER = 20,
CONDITION = '[measures].currentmember.name = "Act YTD"';

What's wrong with the MDX code?

I have examined the problem and when I remove the MDX Expression {[Measures].[Act YTD]} from "FOR" and remove the CONDITION statement, then it works... however, the cell calculation should only be calculated on the measure: Act YTD. By the way: "Act YTD" is a calculated member.

Does anyone have experience with Calculated Cells in SSAS 2005? I haven't been able to find much info about this.

Instead of using Calculated Cells I guess could use SCOPE and the following is working:

SCOPE({[Measures].[Act YTD]}, {[P1].[P1].[Report Row Code L5].&[00490965]});
this = (
[P1].[P1965-1]
,
[Measures].[Act YTD]
)
+
(
[P1].[P1965-2]
,
[Measures].[Act LY WY]
);
END SCOPE;

However I also need to set the solve_order. Is that possible when using the SCOPE statement?

Thank you in advance for any help.

Best Regards,
Frederick