Skip to Content
avatar image
Former Member

what is SAP HANA equivalent to Oracle Model query

Hello,

what is SAP HANA equivalent to Oracle Model query?

https://docs.oracle.com/cd/B19306_01/server.102/b14223/sqlmodel.htm
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 05 at 05:02 AM

    The MODEL clause is an ORACLE specific extension to SQL and not part of standard SQL.

    SAP HANA provides multiple modelling tools, supporting a variety of use cases. For multi-dimensional queries SAP HANA natively supports MDX which also serves as the query language used by the MS Excel/SAP HANA integration.

    Add comment
    10|10000 characters needed characters exceeded

    • No worries, Adi. As it’s usually not successful to look for 1:1 features in platform specific features across different platforms, how about you explain what you want to achieve. Maybe that way we can recommend a good approach to do that on SAP HANA.