An extension to the cube 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 connect dimension calculation views so that you significantly expand the analysis capabilities by providing additional attributes. For example, if you create a sales cube calculation view, which provides only limited attributes such as a product number, you could then join the product dimension calculation view to provide many more product related attributes such as product description, supplier, color and price. You could then aggregate the sales revenues by product color, supplier and so on.
Cube with star join calculation views are the most advanced type of calculation view and are popular in analytical scenarios where ad-hoc analysis is required. Cube with star join calculation views are processing by a dedicated SAP HANA Cloud OLAP engine to provide high performance.
The type of joins between the fact and dimension tables within the star schema can be defined in the Star Join node. The available joins are as follows:
Shared Columns from DIMENSION Calculation Views
In a cube with star join calculation view, the Columns tab of the Semantics node separates columns into two categories:
Private columns are columns that are defined inside the calculation view itself. These can be measures or attributes. You have full control over these columns.
Shared columns are columns that are defined "externally", in one or more dimension calculation views that are referenced by your cube with star join calculation view. On these columns, you have logically less control, because they are potentially "shared" with other cube with star join calculation view. Still, you can hide some of these columns to keep only the ones that you need.
Regarding the shared columns, their Name and Label properties cannot be changed, compared with a private column, but you can define an Alias Name and an Alias Label. Moreover, providing Alias Names is mandatory if column names from the underlying dimension calculation views conflict with each other or conflict with the private column names.