Skip to Content
0

what is SAP HANA equivalent to Oracle Model query

Mar 04 at 11:23 AM

38

avatar image
Former Member

Hello,

what is SAP HANA equivalent to Oracle Model query?

https://docs.oracle.com/cd/B19306_01/server.102/b14223/sqlmodel.htm
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Mar 05 at 05:02 AM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Lars for the feedback, I will read about the MDX, however, I would really appreciate it if you could share with me if SAP HANA (MDX) is able to update the existing values of the measures (in the model) and also generate new values for the dimensions (in the model)?

0

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.

0