Private Reuse and Query views in HANA

[Former Member]

When you create custom views (models) how would you classify as private, reuse and Query views?

In SAP provided views they classified the views into Private, reuse and query views.. we would like to categorize our views in the same way. Take a look at the attachment for how SAP provided views are classified.

thanks

[former_member186082]

Hi Vaithi,

This categorization of views is in SAP HANA Live, and functionalities are as below.

• Private views are abstraction layer for SAP tables. These views are used in Re-use views. Private views cannot be modified.
• Re-use views are built on top of Private views and we can use Re-use views to build Query views.
• Query views are created on top of Re-use views and we use Query views for reporting in reporting tools.

In general when we create models, we don't categorize this way because we use Attribute views, Analytic views and Calculation views according to our requirement. But in HANA Live, all models are calculation views and hence they are divided into separate categories.

Are you planning to categorize models created by you or copying the HANA Live views and want to classify them?

Regards,

Chandu.

[Former Member]

Chandu, thanks and yes we aware of definitions of  private, reuse and query views. And would like to categorize the models we create into private, reuse and Query views and all of our custom models (and all of them are going to be in calculation views).

thanks

[former_member182114]

Hi Vaithi,

Do you want tag it like standard content does to see classificated on SAP Hana Live Browser?

I took a look on views and found that this information came from table ACTIVE_TAGS with tag = fncViewLayer. I don't think it's possible to customize it so if you want you will insert it there like standard developers did:

select * from _SYS_REPO."ACTIVE_TAGS" where tag = 'fncViewLayer';

select * from _sys_bic."sap.hba.explorer.views/ViewsData"

where VIEWLAYER is not null;

Regards, Fernando Da Rós

[Former Member]

Thanks Fernando!   Yes it is more of organizing our views and look in HANA live browser.

[former_member184969]

I have seen screenshots from SAP developpers, where you can see they actually have a tool  - a viez in HANA Studio - so that they can access/update directly to view categories and characteristics (related SAP module, private/reuse, etc)

Why is it that such tool is not accessible to every other developper ?