Unknown members in report parameter causes CONSTRAINED flag error in STRTOSET function when nullProcessing Unknown member
Hi, I'm using MS Report Designer 2005 and have created a report that uses a cube, with a dimension set up to convert null values to unknown (nullProcessing = UnknownMember). When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg: STRTOMEMBER(@DimOrganisationBUSADDRSTATE, CONSTRAINED). When running the report and selecting the 'Unkown' valuefrom the parameter list, the error 'the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated' occurrs. How can I prevent the constrained flag from being used, or am I doing something wrongwith converting null values to 'Unknown'? Thanks
May 1st, 2007 6:26am

Hi All, I have exactly the same problem. In my report I have cascading parameters and independant parameters. In both cases, if I use the unknown member I obtain the error 'the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated'. I really need to use the unknown member and I don't know what to do... Any idea is welcome. Thanks. Guillaume
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2007 7:08pm

I do have same problem... did you get to solution for same..? if yes please share with me. thank you Sandip
June 18th, 2008 10:13am

I am also facing the error. Have u solved this problem?
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2008 11:04pm

In my case I'm using something like STRTOSET(@GroupCAG, CONSTRAINED) If my parameter @GroupCAG is having null value in that case I'm getting this error. that was solution for me. Sandip
July 22nd, 2008 9:55am

Not sure this would be a solution for you, if the unknown member doesnt make any sense in you parameter list cant you avoi it with in the query? this is what i tried WITH MEMBER [Measures].[ParameterCaption] AS '[Date].[RM Year].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Date].[RM Year].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Date].[RM Year].CURRENTMEMBER.LEVEL.ORDINAL' MEMBER [Measures].[ParameterPeriod] AS '[Date].[RM Year].CURRENTMEMBER.UNIQUENAME' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel], [Measures].[ParameterPeriod]} ON COLUMNS , [Date].[RM Year].ALLMEMBERS ON ROWS FROM (SELECT -{[Date].[RM Year].[All Dates].UNKNOWNMEMBER} ON COLUMNS FROM [InfoBank])
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2008 2:15pm

Did anyone find a solution?
February 27th, 2009 9:55pm

I think the parameter which you are passing to STRTOSET() is incorrect or the logged in user has lost the access on data cube.Sanjay
Free Windows Admin Tool Kit Click here and download it now
March 20th, 2009 7:30pm

I'm having the same error, Did anyone find the solution?
March 11th, 2010 4:02pm

I am facing the same issue...any help?
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2010 9:42pm

I resolved this issue by removing the unconstrained argument from the STRTOSET function for the parameter, i.e. STRTOSET(@Parameter,Constrained) to STRTOSET(@Parameter). Ben Lezin
May 17th, 2011 8:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics