SAP HANA EXAM 2025 QUESTIONS AND
ANSWERS
Cube
vs. Cube with Star Join - ANS CUBE
- mandatory to specify at least one column as measure; otherwise, the view activation fails.
Also, if the value is set to cube, an additional column called aggregation is available to specify
the aggregation type for measures.
- multidimensional
- Bref, flexibility, for aggregation type for measures, to use calc view for reporting, calc view can
be consumable via others besides SQL, measures are offered / hierarchies
- Need to create X amount of calc views
- :Need X amount of nodes to complete calc view
STAR JOIN
If you do not check the star join in sps07 when you select "CUBE" as your data category then
the default node will be set to aggregation (for multidimensional reporting) instead of star join.
1) To make the calculation View which needs only joins and aggregations are not required.
2) These views ( Data category = Dimension ) in star join .
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
,Dimension
vs. Cube - ANS DIMENSION
- output node does not offer any measures (or hierarchies), only attributes, which can be
numerical data types
- calculation view is not available for reporting.
- The calculation view is only consumable via SQL.
- The default node is PROJECTION
View - ANS View type of data, e.g.
Graphical vs. Script (SQL, CL,)
Calculation, Attribute i.e. dimensions, Analytic i.e. cubes
Actual vs. Planned - ANS Actual data vs. Planned data for future. Can have Comparison, can
UNION, etc.
SQL Script - ANS SAP Hana SQL innovative version that operates at DATABASE level rather
than application level
(SAP boasts that this improves performance, etc.)
Referential Join - ANS Same fields reliably referenced in both tables being joined
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
, Star Join - ANS SAP HANA SP7 has a key feature called STAR JOIN in Calculation View. This
feature allows us to easily Model STAR JOIN when modeling with multiple fact tables where we
need measures from multiple fact tables
Graphical vs. Script
Calculated Views - ANS Graphical - visual version sans custom scripts
Script - uses customized SQL script
Calculated View - ANS Includes Scripting and Graphical views
SAP HANA Calculation view is a powerful information view. Calculation View can contain
multiple measures and can be used for multidimensional reporting or no measure which is used
in list type reporting. (SAP HANA Analytic view measure can be selected from only one fact
table.)
OLAP - ANS Multidimensional Capability.
The OLAP Processor, a component of the BI server, lies between the user and the database: It
makes the multi-dimensionally formatted data available to both the BI front end and, using
special interfaces (Open Analysis Interfaces) to third-party administrator front ends too. For this
reason, the OLAP processor is optimized for the analysis and reporting of very large datasets.
Users can request ad hoc individual views of business-relevant data using the Business Explorer
(see BI Suite: Business Explorer).
The following graphic displays the status and tasks of the OLAP processor within the data
processing process when a multidimensional analysis is executed:
BW - ANS SAP Business Warehouse
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 3
ANSWERS
Cube
vs. Cube with Star Join - ANS CUBE
- mandatory to specify at least one column as measure; otherwise, the view activation fails.
Also, if the value is set to cube, an additional column called aggregation is available to specify
the aggregation type for measures.
- multidimensional
- Bref, flexibility, for aggregation type for measures, to use calc view for reporting, calc view can
be consumable via others besides SQL, measures are offered / hierarchies
- Need to create X amount of calc views
- :Need X amount of nodes to complete calc view
STAR JOIN
If you do not check the star join in sps07 when you select "CUBE" as your data category then
the default node will be set to aggregation (for multidimensional reporting) instead of star join.
1) To make the calculation View which needs only joins and aggregations are not required.
2) These views ( Data category = Dimension ) in star join .
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 1
,Dimension
vs. Cube - ANS DIMENSION
- output node does not offer any measures (or hierarchies), only attributes, which can be
numerical data types
- calculation view is not available for reporting.
- The calculation view is only consumable via SQL.
- The default node is PROJECTION
View - ANS View type of data, e.g.
Graphical vs. Script (SQL, CL,)
Calculation, Attribute i.e. dimensions, Analytic i.e. cubes
Actual vs. Planned - ANS Actual data vs. Planned data for future. Can have Comparison, can
UNION, etc.
SQL Script - ANS SAP Hana SQL innovative version that operates at DATABASE level rather
than application level
(SAP boasts that this improves performance, etc.)
Referential Join - ANS Same fields reliably referenced in both tables being joined
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 2
, Star Join - ANS SAP HANA SP7 has a key feature called STAR JOIN in Calculation View. This
feature allows us to easily Model STAR JOIN when modeling with multiple fact tables where we
need measures from multiple fact tables
Graphical vs. Script
Calculated Views - ANS Graphical - visual version sans custom scripts
Script - uses customized SQL script
Calculated View - ANS Includes Scripting and Graphical views
SAP HANA Calculation view is a powerful information view. Calculation View can contain
multiple measures and can be used for multidimensional reporting or no measure which is used
in list type reporting. (SAP HANA Analytic view measure can be selected from only one fact
table.)
OLAP - ANS Multidimensional Capability.
The OLAP Processor, a component of the BI server, lies between the user and the database: It
makes the multi-dimensionally formatted data available to both the BI front end and, using
special interfaces (Open Analysis Interfaces) to third-party administrator front ends too. For this
reason, the OLAP processor is optimized for the analysis and reporting of very large datasets.
Users can request ad hoc individual views of business-relevant data using the Business Explorer
(see BI Suite: Business Explorer).
The following graphic displays the status and tasks of the OLAP processor within the data
processing process when a multidimensional analysis is executed:
BW - ANS SAP Business Warehouse
Copyright ©2025 BRIGHTSTARS ALL RIGHTS RESERVED 3
