You need to create the calculation for SalespersonName.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. Create a computed column in the data warehouse’s DimSalesperson table. Include the column in the Sales Reporting model’s Salesperson table.
B. Modify the data warehouse’s DimSalesperson table and add a new column. Use an UPDATE statement to populate the new column with values. Update the SSIS package developed to populate the data warehouse’s DimSalesperson table to use a Derived Column transformation to produce the calculation.
C. Configure the Sales Reporting model’s Salesperson table properties to be based on a query.
Define a derived column in the query.
D. Add a calculated column to the Sales Reporting model’s Salesperson table by using the Data Analysis Expressions (DAX) language CONCATENATE function.
E. Create a view in the data warehouse that defines a derived column based on the DimSalesperson table. Base the Sales Reporting model’s Salesperson table on the view. Include the column in the Sales Reporting model’s Salesperson table.
F. Add a calculated column to the Sales Reporting model’s Salesperson table by using the Data Analysis Expressions (DAX) language ADDCOLUMNS function.
