1 Reply Latest reply: May 26, 2017 3:55 AM by Dimitrios Apostolopoulos RSS

    SAP BW OLAP - How to filter a dimension (where clause or variable) ?

    xavier roty

      Hi all

      Hereto is my OLAP request. I am using QvSAPOLAPConnector and I want to keep only the data where in the field [IOINSIND] value is equal to 'F'.

      Both statements below didn't work.

      Do you have a clue for me or am i doing something wrong ?

      Thanks for your help

      Regards

      Xavier

       

      LET vValue = 'F';

      *************************

      First test

      *************************

       

      [$MYQUERY]:

      Load *;

      Select PseudoMDX (

      Dimensions (

          [IORUNIT] (),            //first dim

          [IOINSIND] ()),         //second dim

       

      Measures (

        [0MEASURES000001].[0VALUE1LC0000001]), //Amount

      Variables (

                  [IOINSIND]        (I = [IOINSIND].[$(vValue)])),

      From ($PCFGL0001))

      ;

       

      *************************

      Second test

      *************************

      [$MYQUERY]:

      Load *;

      Select PseudoMDX (

      Dimensions (

          [IORUNIT] (),            //first dim

          [IOINSIND] ()),         //second dim

      Measures (

        [0MEASURES000001].[0VALUE1LC0000001]), //Amount

      WHERE      {[IOINSIND].[$(vValue)]};

      ;