Q 1. You create a SQL Server 2008 Analysis Services (SSAS) solution. The solution contains a time dimension named DimTime. You have a table named FactSales that contains the two columns named OrderDate and ShipDate. The two columns refer to the DimTime dimension. You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table for both OrderDate and ShipDate. What should you do?
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:
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?
You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. You create the dimensions as shown in the following table.
The CustKey attribute is used as a column in a table named FactSales. You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension. What should you do?