2 Replies Latest reply: Oct 5, 2012 1:14 PM by Sumant RSS

    MDX + RSQLGenerateSet + RSQL + Like + Special Characters

    Sumant
      Hi,
      I am trying to prepare MDX where I am using RSQLGenerateSet.
      The RSQL query in RSQLGenerateSet doesn't work when I use Like with it.

      for example
      with 
      set [Parts] as 
      'RSqlGenerateSet("select PART from PARTS_RS where PART in (''%ABC%'')",[PART],"PART","")'
      ......
      Above returns no values, however if I execute normal RSQL query where I do like '%ABC%' it returns values.

      if I put Like in MDX as below
      set [Parts] as 
      'RSqlGenerateSet("select PART from PARTS_RS where PART like ''%ABC%''",[PART],"PART","")'
      ......
      It throws error.

      Any idea, how to resolve this?

      Thanks,
      Sumant