1 Reply Latest reply: Jul 29, 2014 1:06 PM by Alejandro Urrego RSS

    Where condition is not working in Cubes

    Antony Napolean

      Hi All,

       

              I used where condition in following script but it is not working. it showing full data only. i do not know whether i am making any mistake in the condition. the data fetched from Cubes via SAPOlapconnector.

       

      [$0SD_C03]:

      Load *;

      Select PseudoMDX D (

      Dimensions (

        [0CALYEAR] (),

        [0FISCPER] ()),

      From ($0SD_C03))

      where  [0CALYEAR] = 2013

      ;

       

      can any one help me.

       

       

      Regards,

      Antony.

        • Re: Where condition is not working in Cubes
          Alejandro Urrego

          Hi Antony,

           

          If you need use the sentence where in the load of a cube, you have that add the follow line:

           

          [$0SD_C03]:

          Load *;

          Select PseudoMDX D (

          Dimensions (

            [0CALYEAR] (),

            [0FISCPER] ()),

          Slices (

            [0CALYEAR].[2013]),

          From ($0SD_C03));

           

          Please try with this code, but you may that check the value of the value field.

           

          Regards!.

           

          Alejandro Urrego