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

Performance issues when we call Graphical View within Scripted CV/Procedure?

Hi There,

I have an Analytical view where I used Temporal condition on Date fields, now I wanted to convert the Analytical view as a Graphical (CV)view or a Scripted view.

Based on the above scenario I have 3 questions:

1. If I wanted to make a Graphical CV is there any possibility I can apply Temporal condition on Columns or any other alternate ways?

2. If wanted to make a Scripted View can I use the Graphical View within Scripted CV (Instead of tables)?

3. Is there any difference if I use SQL Engine for Graphical View and use in Scripted CV?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 21, 2016 at 02:01 AM

    You can do it using Graphical Calculation view, which is future proof and Performance effective.

    Just check the steps using below link to create the CV with temporal join.

    Create Temporal Joins - SAP HANA Developer Guide for SAP HANA Studio - SAP Library

    And Answer to your question is as below:

    1. Yes you can do as I have mentioned above.

    2. Yes you can call Graphical CV in Scripted CV, but as Scripted CV is not recommended, unless it is must needed. SAP is suggesting to go with Table UDF.

    3. Theoritically no, as we are forcing the CV to execute in SQL engine.

    I would suggest you go with Graphical CV.

    Regards,

    Chandan

    Add a comment
    10|10000 characters needed characters exceeded

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.