The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated

[Anonymous]

Greetings,

I am working with Report Builder parameters. I have two identical datasets (ds and ds1), derived from the same cube, with a field called Year Number in a folder called Date and a measure called Direct Claim Deductible Recoverable End of Year.

I also have a parameter in the Query designer of ds:

A parameter called DateYearNumber also exists in the Parameters list on the Report Data pane, with the following properties:

Back in the dataset properties of ds0, the parameter name is DateYearNumber and the Value is @DateYearNumber.

Yet when I run the report and select a year from my parameter, it comes up with this error message:

So, what do I do?

[v-xiaoyan-msft · Accepted solution]

Hi @Anonymous ,

When the CONSTRAINED flag is used, the set specification must contain qualified or unqualified member names or a set of tuples containing qualified or unqualified member names enclosed by braces {}. This flag is used to reduce the risk of injection attacks via the specified string. If a string is provided that is not directly resolvable to qualified or unqualified member names, the following error appears: "The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated."

For more information，you may refer to StrToSet (MDX) - SQL Server | Microsoft Learn

You may also check the thread below to see if helps

reporting services - SSRS - the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated - Stack Overflow

Best Regards,
Community Support Team _ Caitlyn