PdfPrep.com

What should you do?

You need to create the hierarchy in the AdhocReports project.

What should you do?
A . Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command.
B . Use the RELATEDTABLE() function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command.
C . Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command.
D . Use the RELATED() function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command.

Answer: D

Exit mobile version