Skip to Content
Technical Articles

FAQ Modeling HANA Calculation Views in Web IDE

This blog is intended to provide answers to frequently asked questions around Calculation View modeling in Web IDE. Topics that are covered are for example what are projects, how do projects relate to containers, or how to manage access to objects.

The individual questions and answers can be found under this link.

When the document will be updated, I will add a comment on the blog post here, so please follow the blog to get notification of any updates.

For a general overview of the differences between modeling in Web IDE compared to HANA Studio have a look at this blog.

For a general overview of the migration approach from the deprecated HANA repository to the new HANA Deployment Infrastructure (HDI) Calculation Views have a look at this blog.

For an example how to move an on-premise Calculation View project in XSA to SAP HANA Cloud have a look at this learning article. See here for background information on the concepts used in the learning article like “schema.configure” or “logical schema”.

11 Comments
You must be Logged on to comment or reply to a post.
  • Hi Jan, hope you are well… How do I read the external generated hana views (created by BW/4HANA under _SYS_BIC) in web IDE?

    I’ve been trying to create synonyms referencing those views (for that I created a logical system name for _sys_bic and then a User provided service pointing to sys_bic) – which by the way I’m unsure if it’s the right thing to do at this stage, but WebIDE complains about the fact that the logical schema is not referenced anywhere in the files.

    Bear in mind that I’m using HTA for HDI and the container was created in BW/4HANA.

    This seems to me a pretty common scenario among those who use BW/4HANA and develop calc. views, to be able to reference an external generated view in a custom calc. view, but I cannot find any documentation covering this scenario.

     

    Thanks in advance, Cristina

    • Hi Cristina,

      from Web IDE perspective you can treat the Calculation Views in _SYS_BIC as any object in other schema (in general we do not recommend to use these old type of views in HDI views if there is not a good reason). So using a synonym would be fine.

      HTA for HDI, however, does not support references to objects in schema _SYS_BIC as this would prevent zero downtime options during upgrades. Therefore, HTA for HDI will not work with external views of BW as long as BW generates these old type of views.

      For ADSOs, building on the exposed SQL Views (SAP Note “2723506-External SAP HANA SQL View with SAP BW/4HANA 2.0”) might be an option.

      Best,

      Jan

       

       

  • Hi Jan, Thank you for the blog on XSA FAQ. I would like to know, do we need to have Web IDE installed and connected to production system? in one of your FAQ, you said that, we don’t connect Web IDE to Prod, if so, then how do manage the HDI containers in Production space run time. For example, how do I grant authorization on HDI container to database user?  Currently in Dev, I do this in DB explorer of Web IDE, by adding HDI container and then access Admin console — > run the DI procedures to grant the HDI roles to classic DB user.

    • Hi Sreekanth,

      even though Database Explorer appears as a kind of link in Web IDE it is not included in Web IDE.

      In other words you do not have to install Web IDE to make use of Database Explorer.

      If you want to navigate to Database Explorer without Web IDE you can for example, navigate to it from HANA Database Cockpit, or directly with the URL, or you navigate to your controller page: https://<host_name&gt;:3<instance number>30 There you should see an entry like “hrtt-core”.

       

      Best,

      Jan

      • Thanks Jan for the reply. But I navigate to the DB Explorer with URL or from Cockpit, I can only work on classic Database objects. But I can’t add HDI containers which got deployed in my production space. firstly, is it something possible to do?  if yes, then am I missing any authorizations in production space?

        /
        • Hi Sreekanth,

          did you assign your user to the respective SPACE in which the hdi-service is running? You will only see the services that are running in your assigned SPACE.

          Having said that: you could also grant the hdi-roles via recent HANA Database Cockpit (Role Assignment). Also, you could grant the respective privileges to a dedicated database user and work with this database user.

          Best,

          Jan

  • Hello all, I have aproblem here, I can not anymore create or edit my calculation views in a hana database using hdi containers, the gráficas calculation view and many other are not being shown anymore in the sap web ide . Can someone help me to solve this ? I tested with the p user and the s user but I get the same error.

    • Hi Silas,

      this does not sound like a question on modeling in Web IDE in general. Please open an incident at SAP support on component HAN-WDE-EDT-MOD for an on-premise issue and CA-WDE-EDT-MOD
      for an HANA Cloud issue. Please provide more details there: E.g.

      • which Web IDE version are you using
      •  it sounds like it worked before, what happened in between?
      •  you speak of “many other are not being shown” what are these others?
      •  what is meant with “not being shown”: you don’t see the design-time objects listed in the folders, or the editor does not open, or data preview does not work?
      •  what is a “p user” what is a “s user”?

      Best,

      Jan

  • This is the list of changes in the linked FAQ document on HANA Modeling in Web IDE:

    • Enhanced section on how to refer in different systems to different objects (e.g., in a transporting scenario)  with the information that schema.configure can also be used with several schemas using one single user provided service

     

    • Enhanced information on how to deploy to a “reuse” container using Web IDE, added a section on how to easily trace the deployment process, and added a section on the question how to transition from on premise to HANA Cloud