Hugo is working on a Cube with Star Join Calculation view CV_SALES_DATA_PRODUCTS that references a graphical Dimension Calculation view called DIM_PRODUCTS with a level hierarchy. Hugo has selected an option called “Enable Hierarchies for SQL Access” in the view CV_SALES_DATA_PRODUCTS. What is the usage of this option?

This option helps to include a new node column for the hierarchy. This column can be used via SQL console for displaying filtration and aggregation of data
This option helps to include a new node column for the hierarchy. This column can be used via SQL Access tool for displaying filtration and aggregation of data
This option helps to include a new node column for the hierarchy. This column will be displayed in the Data Preview of the model to show the hierarchy
This option helps to include a new node column for the hierarchy. This column can be used via Microsoft Excel for displaying filtration and aggregation of data
Correct Option - a

To get all Infosys Certified SAP HANA Basics Consultant Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in