You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee
that includes the following columns:
EmployeeKey
ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?
A.
Create a Named Calculation that uses EmployeeKey and ManagerKey
B.
Create a relationship by using EmployeeKey as the source column and ManagerKey as
the destination column.
C.
Create a Named Query that uses a relationship with EmployeeKey as the source column
and ManagerKey as the destination column.
D.
Create a relationship by using ManagerKey as the source column and EmployeeKey as
the destination column.