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 include several values, but my list is huge, and sometimes new values are added, so I would like to exclude a single value instead, but cannot work out how.

 

Can someone please help?

 

Here is how a single value is included, but how can i exclude that same value?

{Cube.ApplyParameter, "[!V000003]", {{"[ZMTPAYCO__ZMTPAYCAT].[LABO]"}}}

Need Help

2 Replies

    • 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]