Cube.ApplyParameter Multiple Values

[tb86]

Hi,

I'm trying to pass multiple values parameters to SAP BW by usig a text parameter. 

If i write the multiple values hard in "Cube.ApplyParameter" like

{Cube.ApplyParameter, "[P_PRJ]", {{"ProjA", "ProjB", "ProjC"}}},

It works, but if i decline a variable or parameter with the same text and pass it into Cube.Applyparamter, error messages appear, that multiple values are not allowed or it is a invalid MDX command.

#"var Proj" = Text.Combine({"ProjA", "ProjB,", "ProjC"},","),

"""ProjA"", ""ProjB"", ""ProjC""" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=false]

I would be very thankful for tips or solutions!

[tb86]

Hi Winniz, 

thanks für your anwer, but if use a list instead of the parameter it appears following error:

Expression.Error: We cannot convert a value of type List to type Text.
Details:
Value=[List]
Type=[Type]

[v-kkf-msft]

Hi @tb86 ,

{{"ProjA", "ProjB", "ProjC"}} is a list, but the output value of your variable is not a list.

Best Regards,
Winniz