Before creating calculation views, you must fully understand the purpose of each type of calculation view so that you can choose the type that meets your requirements.
SAP HANA Cloud supports the following types of graphical calculation views:
|Calculation View Type||Properties||Default Upper Node|
Used to create re-usable master data views. This is mostly done to provide dimensions to the CUBE with Star Join, but also possible to consume DIMENSIONS directly by some clients.
|CUBE||Use for data analysis with multidimensional, ad-hoc navigation, but no dimensions allowed.||Aggregation|
|CUBE with Star Join||Similar to a CUBE dimension view except the ability to join dimensions using calculation views of type DIMENSION.||Star Join|
DIMENSION Calculation Views
Watch this video to learn more about the Dimension Calculation Views.
CUBE Calculation View
When you want to create a view that includes measures, you use a calculation view of the type CUBE. By default, the result of this type of view will always be aggregated by the attributes requested by the external query. So, even though the calculation view may be able to provide many attributes and measures, the measures are always automatically aggregated by the attributes that were requested by the query. This behavior is different to the SQL Access Only calculation view type.
This type of calculation view is optimized for OLAP style analysis, where slice and dice is required over the measures by any combination of attributes within the model.
A CUBE calculation view does not allow dimensions (based on DIMENSION type calculation views) to be included. All attributes used in analysis come from within the defined model.
CUBE Calculation View with Star Join
An extension to the basic CUBE type of calculation view is the CUBE with Star Join.
In addition to the capabilities of the CUBE type of calculation view, a CUBE with Star Join calculation view allows you to join DIMENSION calculation views to the basic model so that you significantly expand the analysis capabilities. For example, if you create a basic sales cube which provides only limited attributes such as customer and product, you could then join the PRODUCT dimension calculation view to provide large numbers of useful attributes that further describe the customer or product. You could then aggregate the sales revenues of the cube by customer industry, product color, and so on, rather than by the dimensions.
Virtual Data Models for Multidimensional Scenarios
In this scenario, a Cube with Star Join calculation view enables multidimensional reporting that leverages the source transactional data (joining the VBAP and VBAK tables) and then adds three DIMENSION calculation views Product, Customer and Employee
Multidimensional tools support hierarchies for navigation, filtering and aggregation, as well as prompts (variables and input parameters) for efficient pre-filtering of data.