Skip to Content
author's profile photo Former Member
Former Member

SAP HANA Database Views - Use in SAP HANA Modeling components

I just wanted to confirm that a database view in a SAP HANA schema cannot be used in an Attribute View, Analytic View or graphical Calculation View. Has
anyone else experienced this limitation? I was able to use them in a stored procedure and then use that procedure's column view in a calculation view.
While that did work, it requires a significant amount of development just to use a database view in a model.

I'm running both Studio and SAP HANA v 45 (SPS5)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 30, 2013 at 11:39 PM

    Confirmed. This is not possible.

    The problem here is this: what you create with the modelled views are in fact not just fancy SQL statements, but rather complex combinations of rather basic operations present in the different execution engines in HANA.

    These cannot be mapped 1:1 between SQL (the SQL you would have in your views) and the other engines. Technically you would have to execute the view completely, maybe without even pushing filters down, and work further on a potentially large intermediate result set.

    As the main objective of HANA modeling is high performance, this approach is not feasible (it's similar to mixing SQL and ce_-functions in your scripted calc view).

    So SQL views are out of the game here. (and before you ask: synonyms are as well - but I don't know the technical reason for that...)

    - Lars

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jonathan,

      Talking from SLT point of view , Transformation logics like change in Fields metadata, addition of new fields, table partitions are allowed using Transformations Rule (event based rule and parameter based rules

      Also it allows to add ABAP logic, either via single line of code or we can also include ABAP program.

      When it comes to comparing SLT transformation logic to already existing SAP EXTRACTORS , SAP EXTRACTORS richer than SLT transformations .

      also BODS(data services ) provides flexibility of adding more complex logic than SLT.

      Regards

      Praveen Kumar

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.