This content has been marked as final. Show 3 replies
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 (
[ER7BAVBI1ZMD757MA77IZOT1O].[EXLHQV7A64UDMNRAX6C3INQJ0], //Quantity Total Stock
[ER7BAVBI1ZMD757MA77IZOT1O].[EVGRLJ8OSR3PHHKQPIMKOC3D8]), //Valuated stock qty
Will really appreciate any help!