Brian hi, thanks for getting back to me I appreciate your help. I edited the code but without success; did I do it right?

The view returned is to show the measures for each month over the last n months, where n is the lag months value and the date from is the first date value

With Member [Measures].[Measure1] As [Measures].[PI002 Rent Collection Ratio RAT (%)]

Member [Measures].[Measure2] As [Measures].[Value Rent Period Debit]

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]

Member [Measures].[Measure4] As (([Measures].[Value Rent Period Receipts]*-1)/[Measures].[Value Rent Period Debit])

Select {[Measures].[Measure1]

,[Measures].[Measure2]

,[Measures].[Measure3]

,[Measures].[Measure4]

} On Columns

,(StrToMember(@FirstDate,Constrained).Lag(@LagMonths):(StrToMember(@FirstDate,Constrained)) On Rows

FROM ( SELECT ( STRTOSET(@TenancyTenure, CONSTRAINED) ) ON COLUMNS

FROM [CBIHousing])

Where(

[Property V].[Reporting Rent Group].[SomeHA]

,

Iif(StrToSet(@TenancyTenure, Constrained).Count = 1, StrToSet(@TenancyTenure,Constrained), [Tenancy].[Tenancy Tenure].currentmember)

)

;

Here's the error text

TITLE: Microsoft SQL Server Report Builder

------------------------------

Query preparation failed.

------------------------------

ADDITIONAL INFORMATION:

Query (11, 18) Parser: The syntax for 'FirstDate' is incorrect. (Microsoft SQL Server 2008 R2 Analysis Services)

------------------------------

BUTTONS:

OK

------------------------------

Here's the parameter settings

LagMonths - no dimension, no hierarchy, no multiple values, Default = 12

FirstDate - no dimension, no hierarchy, no multiple values, Default = 1[Time].[Fiscal Time].[Sep. 15]

TenancyTenure- Tenancy, TenancyTenure, allow multiple values, Default = 'All Tenures'

Any help, pointers would be hugely appreciated

Thank you

Duncan