Cube.ApplyParameter exlude a single value

[Anonymous]

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]"}}}

[v-frfei-msft]

Hi @Anonymous ,

Hope this case can help you.

https://social.msdn.microsoft.com/Forums/en-US/752a819f-2fd4-4555-95c6-2ea233e46214/cubemember-mdx-in-excel-how-to-exclude-just-one-piece-of-a-data-set?forum=sqlanalysisservices

[Anonymous]

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]