SOLVED: Hugo is working on a Cube with Star Join Calculation view CV_SALES_DATA_PROD ...

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

Verified Answer

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.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us