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 Telegram Group https://rebrand.ly/lex-telegram-236dee

Quick Links

Legal

Contact Info