Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

6.8. Browsing Perspectives and Translations

You have successfully created perspectives and translations for the Adventure Works DW cube. To see the effect, you need to be in the Browser tab of the Cube Designer. In the Browser, if you click the Perspective drop-down list box you will see three perspectives: Adventure Works DW (the default perspective that contains all cube objects), Internet Sales, and Reseller Sales. Select the Internet Sales perspective. If you expand the measures in the Measure Group window you will notice that all the measures relevant to the reseller are now not visible. Drag and drop the Sales Amount, English Product Name hierarchy in the Dim Product dimension, and the English Education hierarchy of the Dim Customer dimension to the OWC browser. You will see the sales amount data along with product names and education of customers as shown in Figure 6-30.

To see the translated names in French you need to select the language French (France) in the Cube Browser. As soon as you select the French (France) language you will notice that all the metadata and data members for the hierarchies in the OWC automatically change to values in French for those objects where translations have been defined, as shown in Figure 6-31. Thus you have created translated values in French for a French client who wants to analyze the same values, but who would be able to understand and interpret the results better in French than English. Each language has a corresponding id called ...