Skip to Content
avatar image
Shyam Uthaman

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

Oct 05, 2017 at 10:45 PM | 655 Views

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

SAP HANA
thomas jung | florian pfeffer | lucia subatin | craig cmehil | dirk raschke
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Lucia Subatin
    Oct 06, 2017 at 03:19 AM

    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/2aa5aa246a704e199cd06ca5c84d1155.html

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Lucia Subatin Shyam Uthaman
      Oct 06, 2017 at 02:08 PM

      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.

  • avatar image
    Lars Breddemann
    Oct 06, 2017 at 02:18 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Shyam Uthaman
      Oct 06, 2017 at 04:48 AM

      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/aa47e30c61904a2692380f311e9035dd.html

      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