-
Named sets and double quotes
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|