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 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?

A.
Set the language property of the Date dimension to Spanish.

B.
Set the case sensitive value to true for the collation property of the Date dimension.

C.
Ensure that the Day of Week and Month Name members have translations defined in the Date dimension.

D.
Change the calculated members to use the numeric values of the Day of Week and Month Name members.

Explanation:
Tip: "browsed in Spanish" = "use the numeric values"



Leave a Reply 1

Your email address will not be published. Required fields are marked *