Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]"}}}
Hi @Anonymous ,
Hope this case can help you.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |