I am getting the following error:

"The lastchild expression expects a member expression for the #0
argument, a level expression was used"

while executing:


SCOPE (
[Time].[Time_LastFourYears].[Year].Members ,
[Activity].[Activity for Res and
MS].[Activity].&[InvDORF],[Measures].[Quantity]
);

THIS = [Time].[Time_LastFourYears].[year].lastchild;


END SCOPE;


In addition, I am wondering when this code is executed, at the cube
process time or at the query run time.

Thanks in advance,
Koni.

try anything like:
THIS = ([Time].[Time_LastFourYears].[year].lastchild ,
[Measures].[Quantity]);


"Koni Kogan" <kkogan (AT) haiint (DOT) com> wrote

[Time].[Time_LastFourYears].[year] - Is a reference to a level in the
dimension, the .LastChild function needs a member reference. I suspect
you might want something like:

[Time].[Time_LastFourYears].[year].CurrentMember.LastChild

Which would get you the last child of the current year member.

And with regard to your second question, I believe all MDX calculations
are currently executed at runtime.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <ew3YpKxXGHA.3684 (AT) TK2MSFTNGP05 (DOT) phx.gbl>, kkogan (AT) haiint (DOT) com
says...