You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a data source view (DSV) which owns a table called Worker for Company.com.
There are some columns in the Worker below
* WorkerKey
* BossKey
The BossKey column references the manager of the Workers.
You should make sure that you should create the relationship between the workers and their boss in the DSV.
Which is the correct answer?
A.
You should develop a Calculation which utilizes WorkerKey and BossKey
B.
You should develop a View which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.
C.
You should develop a Query which utilizes a relationship with WorkerKey as the source column and BossKey as the destination column.
D.
through utilizing BossKey, you should develop a relationship as the source column and WorkerKey as the destination column.