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?
1)You should consider developing a View that makes use of UserKey and ManagerKey. 2)You should consider developing a Measure that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column. 3)You should consider developing a Query that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column. 4)You should consider developing a relationship as the source column and UserKey as the destination column using the ManagerKey. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at firstname.lastname@example.org
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us