View existing calculation views in the new Web IDE for SAP HANA

[shyam_uthaman]

Hi,

I created a new project in my XSA. Now I am lost on how I can bring the Packages and views I had built using HANA studio.

In the database explorer, I could see the schemas and tables but I can't find the views anywhere.

Please Help. I've gone through the documentation but couldn't find any examples where an existing view was brought into the XSA screen.

Also, can you please advice if there is a conversion process from calculation views to hdbcalculation views? I need to leverage the new null value handling feature for my existing views.

Regards,

Shyam

[lsubatin · Accepted solution]

The migration guide for calculation views and the objects around them is here (to take them from their XS Classic version into the XS Advanced world in Web IDE for SAP HANA): https://help.sap.com/viewer/58d81eb4c9bc4899ba972c9fe7a1a115/2.0.02/en-US/2aa5aa246a704e199cd06ca5c8...

Cross-container access to get data from your old schema (or just a plain one, like the one you would replicate with SLT, for example) from your hdi-container is explained here (the key is the xs cups command and the synonym as Lars says): https://www.sap.com/developer/tutorials/xsa-create-user-provided-anonymous-service.html

I just caught this because lars.breddemann commented on it... I also replied to this same question on my blog (that did send me a notification), also referencing Thomas Jung's and Rich Heilman's upcoming open SAP course: https://open.sap.com/courses/hana6

[shyam_uthaman · Accepted solution]

Hi lsubatin ,

Repeating the reply to Lars to you too below so that the notification is passed to you too.. 🙂

Please provide your valuable feedback.

_______________________________________________________________________________________

I understand this somewhat now. But let me explain what my requirement is..please suggest a solution here.

I have calculation views that we've built using HANA studio which have fields having data along with null values.

The client wishes to default null values across all of the fields in these views to the default values of their respective datatype. For example, a null field in a column like Revenue (of type decimal) becomes 0.0

From what I understood, there's null value handling available in the Semantics node of a hdbcalculation view in WEB IDE for SAP HANA in XSA.

https://help.sap.com/viewer/e8e6c8142e60469bb401de5fdb6f7c00/2.0.02/en-US/aa47e30c61904a2692380f311e...

I also tried to create a new graphical Calc view and found the checkbox there.

This is a WEB IDE exclusive feature. How can I apply this to a view that we have created via the HANA Studio?

Creating calculated columns to handle nulls will take a lot of effort across hundreds of fields. Would have been great if we could "migrate"/"change" the .calculation views to .hdbcalculation views.

Please advice. Thanks again for your time in reading this.

Regards,

Shyam

[lsubatin · Accepted solution]

First, this is a completely different question and belongs in a new post.

Second, I think you have responded this yourself. You found the flag on Web IDE and in order to get calculation views into that model you need to migrate them. If I were you, I would first test if this solves all of your problems related to null values. The migration is not about just getting the views to show up in a new set of tools. The views (and all other objects) need to be converted to the new model.

Please see the migration guide, it is full of examples you can try out yourself and there is a tool that will take care of most of the objects.

The alternative if you are not ready to migrate is the one you mention, and you are also explaining the downsides of this.

[vanama1 · Accepted solution]

I am trying to ask same question with a slightly different use case, I do have. The requirement we have is to migrate 100+ graphical calculation views along with various sql stored procedures, sql table functions, sql scalar functions, sql scripted views, attribute/analytical views. They are just HANA 1.0 SP12 level currently but not in xs classic though. I see we can use synonyms to access classical schema DB artifacts with in XSA WEBIDE(for HANA) environment. I got that. But before importing my classical schema into DB Explorer, I need to migrate my HANA 1.0 SP12 based graphical calc views content into HANA 2.0 XSA. We don't have "xsc" in the landscape. The migration guide you mentioned is having procedure to migrate from xsc to xsa, I believe. Please kindly share your knowledge if you know.

[lsubatin · Accepted solution]

Hi, satya.vanama ,

First, please don't hijack closed questions and open a new one for your own scenario.

Second, if you are using HANA Studio, the same migration guide applies, that is XS Classic.

[lbreddemann]

What objects you can see and reference in WebIDE depends on the HDI configuration.

Generally speaking, there is no default access to other schemas objects with XSA/HDI containers but you have to explicitly define synonyms for objects you want to use.

The blogs https://blogs.sap.com/2017/05/17/sap-hana-express-xsa-application-part-1/ and https://blogs.sap.com/2015/12/08/sap-hana-sps-11-new-developer-features-hdi/ give a good start on that.

Also: putting usernames as tags does not lead to notifications. Based on blog https://blogs.sap.com/2017/09/13/dont-mention-it-oh-wait-do/ the @https://answers.sap.com/users/9078/shyamuthaman.html (at-mention feature) should work. However, it did not provide me with a user list when writing out this answer.

[shyam_uthaman]

Hi lars.breddemann ,

Thanks for the tip around notifications and the for links you provided.

I understand this somewhat now. But let me explain what my requirement is..please suggest a solution here.

I have calculation views that we've built using HANA studio which have fields having data along with null values.

The client wishes to default null values across all of the fields in these views to the default values of their respective datatype. For example, a null field in a column like Revenue (of type decimal) becomes 0.0

From what I understood, there's null value handling available in the Semantics node of a hdbcalculation view in WEB IDE for SAP HANA in XSA.

https://help.sap.com/viewer/e8e6c8142e60469bb401de5fdb6f7c00/2.0.02/en-US/aa47e30c61904a2692380f311e...

I also tried to create a new graphical Calc view and found the checkbox there.

This is a WEB IDE exclusive feature. How can I apply this to a view that we have created via the HANA Studio?

Creating calculated columns to handle nulls will take a lot of effort across hundreds of fields. Would have been great if we could "migrate"/"change" the .calculation views to .hdbcalculation views.

Please advice. Thanks again for your time in reading this.

Regards,

Shyam