This discussion is archived
2 Replies Latest reply: Oct 5, 2012 11:14 AM by Sumant RSS

MDX + RSQLGenerateSet + RSQL + Like + Special Characters

Sumant Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points