Skip to Content

Switch UNX universe from vendor syntax to ANSI92

I have an UNX-formatted universe that includes a number of Oracle tables (and joins).

I'd like to use ANSI 92 syntax, instead of Oracle's. I know how to actually change the syntax to ANSI92, using the Parameters dialog in the business layer:

screen-shot-2017-08-07-at-31839-pm.png

However, after doing so, the joins in the UNX's queries are not changed. Closing and opening the data foundation and business layer doesn't change the situation nor does closing and opening IDT.

What's the process to get this working?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 07, 2017 at 08:30 PM

    have you tried to updating the ANSI92 parameter in data foundation?

    Datafoundation name->parameters

    Add comment
    10|10000 characters needed characters exceeded