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?

Question

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?

Accepted Answer

D. Create a relationship by using ManagerKey as the source column and EmployeeKey as the destination

Answer

A. Create a Named Calculation that uses EmployeeKey and ManagerKey

Answer

B. Create a relationship by using EmployeeKey as the source column and ManagerKey as the destination

Answer

C. Create a Named Query that uses a relationship with EmployeeKey as the source column and Manager

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…

Question

Options

How the community answered

Community Discussion