Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

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]

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.