You design a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a measure named Sales Amount and a dimension named Date. The Date dimension has a hierarchy named Fiscal that has levels named Fiscal Year, Fiscal Quarter, and Fiscal Month.
You need to create a calculated member to analyze the Sales Amount share percentage at different levels compared to the total sales for a given Fiscal Year.
Which code segment should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution contains a dimension named DimCustomer that represents customers. The solution provides a list of top 10 customers based on the sales amount. End users of the solution analyze data by using filters in Microsoft Excel worksheet. You need to ensure that the list is updated when the filters are applied.
Which named set expression should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis Services (SSAS) solution contains a cube that has the following objects:
Dimensions named DimCustomer, DimProduct, and DimGeography Measures named InternetSales and TotalSales

Users run reports against all dimensions and measures by authenticating with their Windows accounts.
You need to provide a basic view of data to the users to display only DimGeography, DimProduct, and TotalSales by using the least amount of storage space.
What should you do?

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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution uses a source database that contains a table named Customer. The Customer table has multiple columns.
You have read-only access to the database.
You plan to reduce the number of columns in the Customer table. You need to split the Customer table to be distributed across multiple table definitions.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution. Customer data is stored in the tables named CustomerDetails and CustomerContact.
The solution uses the following two data sources from two different servers:
-Contoso that accesses the CustomerDetails table
-ContosoCRM that accesses the CustomerContact table

You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables.
What should you do?

You design a SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The cube uses an English (EN-US) locale.
The cube has calculated members that use the members named Day of Week and Month Name of a dimension named Date to perform date-related operations. You implement translation in Spanish for the cube. You discover that the calculated members are not working correctly only when the cube is browsed in Spanish. You need to ensure that the calculated members work correctly when the cube is browsed in Spanish.
What should you do?

You design a SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The solution has a measure group that contains different measures aggregated by different dimensions. Users often browse the cube by using Microsoft Excel. You need to enable users to view additional row-level information of the aggregated measures from Excel by using the minimum amount of development effort.
Which Action should you create?

You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution has dimensions named Account and Scenario. The Scenario dimension has the keys numbered 1 and 2 for the members named Actual and Budget, respectively. The Account dimension has the key numbered 40 for the member named Income. You create a key performance indicator (KPI) named Net Income that has the following parameters:
KPI Value: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[1], [Measures].[Amount] ) KPI Goal: ( [Account].[Accounts].&[40], [Scenario].[Scenario].&[2], [Measures].[Amount] ) If the net income is less than 70 percent of the budgeted value, the performance is considered as bad. If the net income is greater than or equal to 90 percent of the budgeted value, the performance is considered as good. You need to calculate the performance at a specific point in time.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging strategy for a SQL Server 2008 Integration Services (SSIS) solution. The SSIS solution contains 15 packages. You want to log detailed information about each package. You need to ensure that custom events specific to each control flow task in each package are logged.
What should you do?