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

[Former Member]

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?

[chandan_praharaj]

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