Script to create views

[Former Member]

How to create the views (attribute, analytic, calculation) using scripts rather than following the HANA studio?

This will help in automating this steps involved and increase productivity, especially while migration the application from another database.

[Former Member]

Hi Richard,

Thanks for the reply.

Based on our current understanding of HANA's views, to address our requirement for muti-tenancy and highly dynamic nature of the analytical queries we figured the only option would be to dynamically generate the calculation view based on the user selection of the attributes, measures and measure aggregate functions.

Thought this might not be an optimal or recommended usage, we feel it can address our requirement as long as there is a way to automate these steps without depending on HANA studio. So while evaluating this approach we ran into the below questions:

• The functions CE_CALCULATED_VIEW, CE_JOIN_VIEW can only be called from SQLScript in the Calculation view or they can be executed from JDBC/ regular SQLScript?
• How to create a "SQLScript based Calculation view" using SQLScript/ JDBC API/ XML file for automation?
• When we try to add input parameters to the "Calculation View", there are only options to add Date/Currency/ a predefined set of input  values. Is there a way we can allow the user defined string as input parameter?
• Can Activation of procedures/ calculation views/ attribute views/ join views be done through SQLScript statements in a SQL Editor?

Regards

Rahul

[lucdealethea]

Hi Rahul,

go a little deeper and assess the use of CREATE PROCEDURE WITH OVERVIEW.

Then consume the view created by the procedure.

I think that this should resolve your bullets.

Rgds,

Luc.