I had imported a cube from AS 2000 to SSAS 2005
And one formula I have:

CREATE CELL CALCULATION CURRENTCUBE.[Days]
FOR '({Measures.[Days]}, [Calendar].[Calendar].[Day].Members)'
AS '1'

And what I hoping to get is only number of chosen days. In AS 2000 all
work well and neat, but not in SSAS 2005.

What the problem ?

try to use the scope statement:
scope({Measures.[Days]}, [Calendar].[Calendar].[Day].Members);
this = 1;
end scope;


"SignOff" <alerya (AT) gmail (DOT) com> wrote

Is this right?
CREATE CELL CALCULATION CURRENTCUBE.[Days]
FOR 'scope({Measures.[Days]}, [Calendar].[Calendar].[Day].Members);
this = 1; end scope;'
AS '1'


"""Jeje ÐÉÓÁÌ(Á):
"""

no
replace create cell calculation etc by my statement.

CREATE CELL CALCULATION CURRENTCUBE.[Days]
FOR '({Measures.[Days]}, [Calendar].[Calendar].[Day].Members)'
AS '1'

becomes:
scope({Measures.[Days]}, [Calendar].[Calendar].[Day].Members);
this = 1;
end scope;


"SignOff" <alerya (AT) gmail (DOT) com> wrote

I cant understand how to use the scope to get my calculated cell

Oh thanks a lot, I found. THanks for your post!