PROBLEM:
- create a derived universe to set relation ship between tables
- Set an external join between two tables, we have Systematically an error msg :
[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]syntax error, unexpected LBRACE at name ... {. (WIS 10901)
SOLUTION:
We have to set ansi92:
1. Import the Universe in the Universe Designer Wizard.
2. Click on 'File' -> 'Parameters' and set the parameter 'ANSI92' to Yes.
3. Save and export the Universe.
4. Restart the CABI Services.
5. And check for the issue.