You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution. Your database has a table named DimCustomer that contains columns named FirstName and LastName. You belong only to the db_datareader role in the database. You have added DimCustomer to a data source view. You need to design a solution that includes the following requirements:
-A column named FullName in DimCustomer by using the values from FirstName and Lastname
-The data source view allows you to delete columns from DimCustomer
What should you do?
A.
Implement a named calculation for FullName in the data source view.
B.
Redesign DimCustomer to have a computed column named FullName.
C.
Replace DimCustomer with a named query in the data source view. Create FullName as a column expression in the named query.
D.
Implement a view in the database with FullName as a column expression. Replace DimCustomer with the view in the data source view.
Explanation:
Tip: “FullName by using FirstName and Lastname” = “named query” or “Replace / Create”