Hi,

This should be quite simple but I can't work out the syntax. I need to
create a set starting from the start of the year and stopping at the value in
[ForecastMonth].[Month], which is a different dimension (but equivalently
structured) to my [Time] dimension. I have:

WITH MEMBER ForecastYTD2005 as
Sum({[Time].[Month].[200501]:LinkMember(Time].[Month],
[ForecastMonth].[Month].currentmember}) which generates an error since
LinkMember can;t be used here. What should I try?

This is meant to be used as a total measure , i.e. I need to see a set of
measures on one axes and Account groups on another so that the measures are
time-independent:
ActualsYTD005, ForecastYTD2005, ForecastFY2005, etc
I can't get YTD to work at this total level, it only works when you're
looking at it by month.

TIA,
Rob

Hi Rob,

Looks like you have LinkMember() parameters reversed, unless it's a
typo:

http://msdn2.microsoft.com/en-us/lib...8(SQL.90).aspx

Returns the member equivalent to a specified member in a specified
hierarchy.

Syntax

LinkMember(Member_Expression, Hierarchy_Expression)
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***