Search code examples
obiee

How to deal with apostophe

I am trying to create the calculation below using a the filter function, however, I get a syntax error because of the Bachelor's, my question is how can I fix the issue with Bachelor's without fixing data in the warehouse?

FILTER("Fact - Count"."# of Applications" USING (("Candidate
Education"."Highest Level Education" IN('Bachelor's Degree', 'Higher
Degree'))   AND ("Candidate Education"."Graduated" = 'Yes')))
Solution

  • Escape it. '' double single quote