How to limit Pseudo MDX results based on Measure

[#1]

Hello,

I have an auto generated MDX query using SAP OLAP connector. I want to fetch only the materials which have 0 quantities on the date defined. The query wizard does not allow me to do that and I have tried to add 'Filters' component to the generated query to no avail. Is there a way to achieve the desired?

Select PseudoMDX (

Dimensions (

  [0MATERIAL] (),

  [0MATERIAL__0MATL_TYPE] (),

  [0PLANT] (),

  [0STOR_LOC] (),

  [0WBS_ELEMT] (),

  [0CALDAY] ([20CALDAY]),

  [0CALMONTH] (),

  [0CALYEAR] ()),

Measures (

  [ER7BAVBI1ZMD757MA77IZOT1O].[EXLHQV7A64UDMNRAX6C3INQJ0], //Quantity Total Stock

  [ER7BAVBI1ZMD757MA77IZOT1O].[ETC1G7A3FDD1CBE6HUX1U0G7G], //ValStockValue

  [ER7BAVBI1ZMD757MA77IZOT1O].[EVGRLJ8OSR3PHHKQPIMKOC3D8]), //Valuated stock qty

Slices (

  [0CALDAY].[20170527],

  [0PLANT].[DN01]),

From (ZIC_C03/QREP_QV_STOCK_04))

Will really appreciate any help!

[mats_olin]

Not sure if it will work (if conditions are filtered on when accessing the BEx query throught the MDX interface) but you could try to set a condition in BEx Query Designer for 'Quantity Total Stock'.

[#3]

In Bex, it tells us that upon MDX query access such filters will be ignored.

[mats_olin]

Ok, sorry, then that option will not work/ Mats