Forum Discussion

tb86's avatar
tb86
Frequent Visitor
3 years ago

Cube.ApplyParameter Multiple Values

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!

Need Help

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    3 years ago

    Hi tb86 ,

     

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

     

     

    Best Regards,
    Winniz

     

  • tb86's avatar
    tb86
    Frequent Visitor
    3 years ago

    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]