Using views inside other views

[BenedictV]

Hi,

While designing calculation views we sometime use existing views as nodes.

This we can do by using a projection node and including the view from Content folder or we can include the view table under _SYS_BIC schema in the project node.

Is there any difference in terms of performance or best practice while doing this, or does it not really matter how the view is called.

Benedict

[aadityanigam · Accepted solution]

Hello Benedict,

The best practice is to use design time content (Content folder).

HANA automatically resolves this during activation. Also helps when you export your content from HANA instance to another using delivery units.

As far as i understand the performance is not impacted in anyway.

warm regards

aadi

[Former Member]

Hi Benedict,

It doesn't matter whether you pull the view directly from the Content folder or from _SYS_BIC - HANA resolves both the same way.

A more nuanced question is whether a Calculation View should consume other models, or raw tables directly. But that's a different discussion.

Cheers,

Jody