Skip to Content
avatar image
Former Member

SQL-92 for Single source Universe

Hello -

I am trying to Build a design studio application on top of SAP ERP, Since Multi-source is not supported , i created a single source universe. But the SQL functionality in Single source is database specific, i am not able write formulas in SQL.

is there anyway i can force Single Source Universe to use SQL-92



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 17, 2015 at 08:47 PM

    You can Enable ANSI92 YES

    In the parameters of the universe.

    Go to the Data Foundation

    click on the Data Foundation name in the center panel.

    parameters button is on the bottom right side.

    If ANSI92 is not present then add it in from the drop list.

    Set value to Yes.


    then it is propagated to the Business Layer.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Jacqueline

      Thanks for your reply, I changed the parameter ( also i tried to change it at Business Layer), it is not doing anything for single source universes on SAP ERP.

      I believe this option forces single source universes on RDBMS to use ANSI-92 instead of database specific.

      any ideas?