Posted by: Pdfprep
Post Date: November 27, 2020
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
Leave a Reply