Hi!
I am trying to add a named set to a dataset in RS. The purpose is to set Investigated_Period = Reported_Period. The format is [YYYY].[QQ], e.g. [2005].[Q1].

I am using the following code:

="With
set [Inv_Per_Eq_Rep_Per] as 'strtoset("{[investigated].[INVYear].[" + Reported.CurrentMember.parent.name +"].[" + Reported.CurrentMember.name +"]}")'

member1....
Select....
From....
Where ....)"


When trying to look at the report in "Preview" in RS I get the following error:
BC30205: End of statement expected

I have tried to declare a named set in Analysis Services instead, but I get an error there as well.

Ideas anyone?
I would appreciate your help!