Thursday, 10 August 2017

Calculation View wizard in SAP HANA

The Calculation View wizard window offers you 8 options to be configured or
selected, as outlined in the table.

Property
DESCRIPTION
NAME
v  The name of the calculation view.
v  This is a required property that can’t be changed after the calculation view is saved and activated. It’s important to establish a standard calculation view naming convention before starting a development project in SAP HANA. Only the alphabet characters Aa-Zz, numbers 0-9, and underscore (_) are allowed in the name.
Label
v  The description of the calculation view. This property can contain a free-text description of the calculation view and should be used to add additional metadata to the view or a thorough description that other developers can use to identify the purpose of the calculation view.
PACKAGE
v  The package that the calculation view will be assigned to. Only nonstructural packages can be used as the parent object for a calculation view.
VIEW TYPE
Choose the View Type I.e.,
1.      Attribute View
2.      Analytic View
3.      Calculation View
COPY FROM
v  Choose the Copy From option when there is a need to create a new calculation view that is a copy of an existing calculation view.
v  Select the Browse button to select an existing calculation view. All content from the source calculation view is copied into the new view.
View Type - Graphical
v  Choose the View Type – Graphical option to create a calculation view using graphical objects and workflows.
v  This option doesn’t require you to use SQL code or the SAP HANA Calculation Engine functions.
View Type – SQLscript
v  Choose the View Type – SQLscript option to create a calculation view using SQLscript code or SAP HANA Calculation Engine functions.
v  This option should be used by experienced developers that need to define complex calculations and by developers with a thorough understanding of the SAP HANA Calculation Engine functions.

Data Category
Select a data Category. i.e.,
1. Cube (With or Without Star Join)
2. Dimension
3. Blank


Thank You For Visiting My Blog...
Share Your Comments...

1 comment: