Use only valid and appropriate SQL values. Essbase does not validate values.
Be especially careful with quotation marks (single and double). Different databases require different conventions.
Because the ampersand (&) is the Essbase identifier for substitution variables, do not begin SQL operators in SELECT, FROM, or WHERE clauses with ampersands.