Browsing Perspectives and Translations

You have successfully created perspectives and translations for the Adventure Works DW object. 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, Internet Sales, and Reseller Sales. Select the Internet Sales perspective. If you expand the measures in the Metadata window you will notice that all the measures relevant to the reseller are now not visible. Drag and drop the Sales Amount - Fact Internet Sales, English Product Name hierarchy in the Dim Product dimension, and the English Education Name 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-33.

image from book
Figure 6-33

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, as shown in Figure 6-34. 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 the locale id. When you select a specific language in the Browser BIDS connects to the server with the corresponding locale id for the language. Analysis Services automatically provides you with the metadata and data corresponding to the locale id whenever queries are sent to the server on the same connection.

image from book
Figure 6-34

Instead of creating new cubes for various users and clients understanding different languages and the overhead of maintaining the cubes in each language, Analysis Services 2005 provides you with the functionality through the perspectives and translations features.

Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
Year: 2004
Pages: 176 © 2008-2017.
If you may any questions please contact us: