You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional project

HOTSPOT

You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional project.

You are developing a dimension that uses data from the following table:

The ManagerKey column defines a foreign key constraint that references the EmployeeKey column. The table stores employee history information by using slowly changing dimensions (SCD). Changes to EmployeeName, Phone, or ManagerKey are managed as SCD Type 1 changes. Changes to SalesRegion are managed as SCD Type 2 changes.

You create the following attributes, and set the KeyColumns and NameColumn properties to the columns listed in the table below:

You need to add a parent-child hierarchy to the dimension to enable navigating the organization hierarchy.

In the table below, identify the attribute that you must use for each attribute usage type. NOTE: Make only one selection in each column.

View Answer

Answer:

Explanation:

The ManagerKey column, the Manager attribute, defines a foreign key constraint that references the EmployeeKey column, the Employee attribute.