cancel
Showing results for 
Search instead for 
Did you mean: 

What is the difference between creating a calculation view in HANA content folder and XSA project?

former_member192683
Participant
0 Kudos

Hi,

There are two different ways when we create a calculation view in HANA.

  1. By using Hana studio/eclipse in the content folder under a package
  • In an XSA/XS Classic project as a database artifact with the ".hdbcalculationview" file extension

What is the difference between the two ways?

In the first option, calculation view is created under the global _SYS_BIC schema. But in the second option, it is created under the user-created HDI container's schema. My main goal is calling the view from a reporting tool like SAP BO, Lumira or SAP Analytics Cloud. Before XSA, I've used the first option and I was calling the calculation view from the _SYS_BIC schema in the end. I'm more likely into using the XSA option. But now when I use XSA MTA project to create the calculation view, a new schema and users are created, so it makes it a bit difficult for me to grant privileges to the integration user for the reporting case.

The question is also valid for the comparison of creating calculation view in XS Classic and under HANA content folder. I haven't used XS Classic for calculation views before, but I assume XSA and XSC as the same thing since they both create a custom schema to hold the calculation views.

So, what is the best/up-to-date way of creating a calculation view? Is the first HANA Studio content folder option obsolete?

Thank you,

Ceyhun

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor

Actually the first way via HANA Studio is one way to create a calc. view in XSC. Your assumpation that XSA and XSC are not the same. In XSC the calc. view design time object is stored in the HANA repository and the runtime object is generated in schema _SYS_BIC.

The way to go is XSA, as XSC was set to deprecated with HANA 2.0 SPS02 (XSC will be removed with the next major HANA release).

former_member192683
Participant
0 Kudos

Thank you florian.pfeffer for the valuable information, I'll try creating a calculation view in XS Classic by an XS Classic project, not by the content folder and observe the runtime objects. So whether use content folder or XS projects, they both generate the runtime views in the _SYS_BIC schema.

So, it sounds me like _SYS_BIC scheme will not be that useful in the next major release since XSA doesn't generate the runtime objects in it. Maybe only tables for time data will mean a bit for that schema.

Thank you once again

Answers (0)