Search for HANA views

Definition of SAP HANA Views

Attribute views

• Used to join tables (for example, text table to master tables)
• Used as a projection
• May contain filters
• May have a column with sample calculations
• May be used in analytic or calculation views

Analytic Views

• Used to join tables
• Join the fact tables (data foundation) with attribute views
• Data is read from the joined tables
• Joins and calculated measures are evaluated at runtime
• May contain more sophisticated calculations (currency conversion)

Calculation Views

• Can be created graphically or based on a script (SQL script, CE functions)
• Is designed for sophisticated analysis based on the following:

• Functions defined in the SAP HANA-specific language SQL script.
• Functions that contain SQL commands
• SELECT <FIELDS> FROM <TABLE, VIEW, or COLUMN VIEW)
• SQL in functions must be read-only
• Functions that call other functions
• Modularize the logic with the calculated view
• SAP HANA offers pre-defined functions for creating a join or union of tables

Test and Data Preview