Hi

I was wondering if anyone would have suggestions on how to solve the following mdx problem. I am trying to add a dynamic set in the Analysis Services form script but nothing happens. When I run the query below in Management Studio I get the expected results:

WITH DYNAMIC SET [test] AS
{STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].currentmember.PROPERTIES("Max Accident Year Development Month")) + "].lag(2)"):
STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].currentmember.PROPERTIES("Max Accident Year Development Month")) + "]")}
SELECT [test] ON 0
FROM [Cube]
WHERE ([Measures].[Value],[Accident Period].[Accident Year].&[2012]);

The code below does not work in the script view of BIDS.

CREATE DYNAMIC SET CURRENTCUBE.[Last 2 Accident Year Development Months]
AS
{STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].PROPERTIES("Max Accident Year Development Month")) + "].LAG(2)"):
STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].PROPERTIES("Max Accident Year Development Month")) + "]")}
;

I think the STRTOMEMBER function does not agree with the MDX properties string. Any suggestions would be greatly appreciated.

Thanks in advance.