3 Replies Latest reply: Aug 22, 2017 4:24 AM by Mats Olin RSS

    How to limit Pseudo MDX results based on Measure

    Salik Khan

      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!