1.

You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. Your solution contains a data source view (DSV) that owns a table named CKUsers. The CKUsers table contains a field named UserKey and a field named ManagerKey. The ManagerKey references the manager of the Abc.com user. You need to create a relationship between the users and their managers in the DSV. What should you do?

A. You should consider developing a View that makes use of UserKey and ManagerKey.
B. You should consider developing a Measure that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
C. You should consider developing a Query that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
D. You should consider developing a relationship as the source column and UserKey as the destination column using the ManagerKey.
Answer» E.


Discussion

No Comment Found