You need to add a parent-child hierarchy to the dimensi…

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.
Hot Area:

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.
Hot Area:

Answer:

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *