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

i got problem using multi-value parameters in ssrs.

i got dataset mdx query :

select non empty { [measures].[air temperature out - fact germination continue] } on columns, non empty { ([81 germination continue].[batch number].[batch number].allmembers * [80 germination general].[plant name].[plant name].allmembers * [80 germination general].[production unit].[production unit].allmembers * [81 germination continue].[characteristic date].[characteristic date].allmembers * [80 germination general].[start date unloading].[start date unloading].allmembers * [80 germination general].[start date].[start date].allmembers * [80 germination general].[end date].[end date].allmembers ) } dimension properties member_caption, member_unique_name on rows ( select ( strtoset(@germinationgeneralproductionunit, constrained) ) on columns ( select ( strtoset(@germinationgeneralplantname, constrained) ) on columns ( select ( strtoset(@germinationcontinuebatchnumber, constrained) ) on columns [supervision]))) cell properties value, back_color, fore_color, formatted_value, format_string, font_name, font_size, font_flags

when running report, got error :

the restrictions imposed constrained flag in strtoset function violated.

from research, means have put full name in parameters of dataset. thing think did it, if it's bit different saw, because of construction of datasets. example, germinaction continue batch number, parameter value :

=split(replace(join(parameters!batchnumbers.value, ","), "[70 steeping general]", "[81 germination continue]"), ",") 

as can guess, data come dimension "[70 steeping general]", try put in dimension "[81 germination continue]", values same in both dimension ([81 germination continue].[batch number].[batch number] , [70 steeping general].[batch number].[batch number]

does problem come fact it's multi-value parameter looks this? :

[81 germination continue].[batch number].[1234567890], [81 germination continue].[batch number].[1234567891], [81 germination continue].[batch number].[1234567892] 

edit :

the parameters of report :

fromsteepingstartdate tosteepingstartdate

both date/time parameters , have available value set none, default value dateadd("m", -1, today()) , dateadd("d", -2, today())

they used in dataset datasteeping, , value of parameter

="[70 steeping general].[start day].&[" + cstr(format(cdate(parameters!fromsteepinggeneralstartday.value), "yyyy-mm-dd"))+ "t00:00:00]"

steepinggeneralplantname

this parameter multi-value parameter, initialy come dataset datasteeping, autogenerated dataset has been created, following query :

with member [measures].[parametercaption] [70 steeping general].[plant name].currentmember.member_caption member [measures].[parametervalue] [70 steeping general].[plant name].currentmember.uniquename member [measures].[parameterlevel] [70 steeping general].[plant name].currentmember.level.ordinal select {[measures].[parametercaption], [measures].[parametervalue], [measures].[parameterlevel]} on columns , [70 steeping general].[plant name].allmembers on rows [supervision]

the dataset filtered parameter.level <> 0 , parameter.caption <> "unknown"

this parameter used in every other dataset, don't come same dimension, parameter value in others datasets properties looks this:

=split(replace(join(parameters!steepinggeneralplantname.value, ","), "[70 steeping general]", "[80 germination general]"), ",") 

steepinggeneralproductionunit

this parameter multi-value parameter too, initialy come dataset datasteeping, autogenerated dataset has been created, changed it, doesn't come dimension [70 steepinggeneral], [04 productions unit], contains productions unit, , compatible other dimensions, easier load in other datasets, mdx query :

with member [measures].[parametercaption] [04 production units].[production unit].currentmember.member_caption member [measures].[parametervalue] [04 production units].[production unit].currentmember.uniquename member [measures].[parameterlevel] [04 production units].[production unit].currentmember.level.ordinal select {[measures].[parametercaption], [measures].[parametervalue], [measures].[parameterlevel]} on columns , [04 production units].[production unit].allmembers on rows ( select ( strtoset(@plantsplant, constrained) ) on columns [supervision])

the dataset filtered parameter.level <> 0

this parameter used in every other dataset, dataset datagermination need expression parameter, because it's dimension :

=split(replace(join(parameters!steepinggeneralproductionunit.value, ","), "[04 production units]", "[80 germination general]"), ",") 

tempsteepinglimit

this parameter not important problem, it's temperature limit, need display duration temperature above limit. it's text parameter convert float (with replace user can type "," or "."). has no dataset , used in no one, in textbox expression.

batchnumbers

this hidden parameter populated dataset return batch numbers match other parameters (from/to steeping start date, plant name , production unit). used in 2 dataset (datagermination , databatchprocessdata), because couldn't add steeping start date in datasets.

in datagermination, value batchnumber :

=split(replace(join(parameters!batchnumbers.value, ","), "[70 steeping general]", "[81 germination continue]"), ",") 

the dataset populate parameter not autogenerated, added it, query :

select non empty { [measures].[barley volume] } on columns, non empty { ([70 steeping general].[batch number].[batch number].allmembers * [70 steeping general].[plant name].[plant name].allmembers * [70 steeping general].[production unit].[production unit].allmembers * [65 batch process data].[steeping start date].[steeping start date].allmembers ) } dimension properties member_caption, member_unique_name on rows ( select ( strtomember(@fromsteepinggeneralstartday, constrained) : strtomember(@tosteepinggeneralstartday, constrained) ) on columns ( select ( strtoset(@steepinggeneralproductionunit, constrained) ) on columns ( select ( strtoset(@steepinggeneralplantname, constrained) ) on columns [supervision]))) cell properties value, back_color, fore_color, formatted_value, format_string, font_name, font_size, font_flags

(sorry english)

don't hesitate ask questions!

thank's help! :)