Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cube.ApplyParameter exlude a single value

Hi.   I would like to exclude a sinlge value in my query.   I am connecting to SAP BW, and in the advanced editor, there is a line of code "Cube.ApplyParameter" I can only work out how to inclu...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-frfei-msft 

    Thanks for your reply.

    I am not sure if it is my synatx or this is not supported, but I get an error when I try a couple of different options.

    Can you check if it is supported or it is my syntax?

     

    When I try this:

    {Cube.ApplyParameter, "[!V000001]", {{"Except([ZMTPAYCO].[NONB])"}}}

    I get this error...


    DataSource.Error: The SAP BW server reported an error: 'Invalid MDX command with [Except[ZMTPAYCO]'. To find more information about this error, visit the SAP support site and search for 'BRAINOLAPAPI 100'.
    Additional information may be available in SAP Note '1084454, 1282785, 401607, 1786009'.
    Details:
    DataSourceKind=SapBusinessWarehouse
    DataSourcePath=bipapp.energy.com.au/50/710
    ID=BRAINOLAPAPI
    NUMBER=100
    MESSAGE_V1=[Except[ZMTPAYCO]
    SYSTEM=BIP_710
    Command=SELECT....

     

    When I try this 

    {Cube.ApplyParameter, "[!V000001]", "Except([ZMTPAYCO].[NONB])"}

    I get this error...


    Expression.Error: We cannot convert the value "Except([ZMTPAYCO].[N..." to type List.
    Details:
    Value=Except([ZMTPAYCO].[NONB])
    Type=[Type]