You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube that uses a dimension named DimProducts. The DimProducts dimension contains the following features: An attribute named Product. A column named ProductEnglishName for the
English name of the product. A column named ProductFrenchName for the French name of the product.
The NameColumn property of the Product attribute is set to the ProductEnglishName column. The language property of the cube is set to French.
You need to ensure that the cube displays the product names in French when you browse through the cube from a client that uses the fr-FR locale.
What should you do?
A.
Create a new translation for the dimension and select the ProductFrenchName column as the translation column for the Product attribute.
B.
Create a new translation for the dimension and set the value “ProductFrenchName” for the translated caption of the Product attribute.
C.
Create a new translation for the cube and set the value “ProductFrenchName” for the caption of the DimProducts dimension.
D.
Set the NameColumn property of the Product attribute to the ProductFrenchName column.