Figure 56. Show calculated members from OLAP server check box Note that this property controls only whether calculated members in hierarchies other than the measures hierarchy appear in the PivotTable. Calculated measures appear independent of this setting. When the Show calculated members from OLAP server check box is selected, Excel includes the AddCalculatedMembers function in the Multidimensional Expressions (MDX) query sent to the server. Translations SQL Server 2005 Analysis Services introduces a new feature called translations. With translations, you can now have multiple languages available to end users for dimensions, hierarchies, levels, members, and more. If the Microsoft Office display language exists as a translation on the server, Excel automatically retrieves information from the server in that language. You can configure whether Excel will retrieve translations in the Connection Properties dialog box for the connection to the server. To receive translations, select the Retrieve data and errors in the Office display language when available check box under the Language section of the Usage tab, as illustrated in Figure 57. Figure 57. Setting for retrieving translations from the OLAP server If you need a specific translation, regardless of the Office display language, you can obtain the translation by adding a property in the Office Data Connection (ODC) file representing the server with the OLAP cube. The default connection string section of the ODC file looks like this: <odc:ConnectionString> Provider=MSOLAP.3; Integrated Security=SSPI; Persist Security Info=True; Data Source=MyOLAPServer; Initial Catalog=Adventure Works DW
Figure 56. Show calculated members from OLAP server check box Note that this property controls only whether calculated members in hierarchies other than the measures hierarchy appear in the PivotTable. Calculated measures appear independent of this setting. When the Show calculated members from OLAP server check box is selected, Excel includes the AddCalculatedMembers function in the Multidimensional Expressions (MDX) query sent to the server. Translations SQL Server 2005 Analysis Services introduces a new feature called translations. With translations, you can now have multiple languages available to end users for dimensions, hierarchies, levels, members, and more. If the Microsoft Office display language exists as a translation on the server, Excel automatically retrieves information from the server in that language. You can configure whether Excel will retrieve translations in the Connection Properties dialog box for the connection to the server. To receive translations, select the Retrieve data and errors in the Office display language when available check box under the Language section of the Usage tab, as illustrated in Figure 57. Figure 57. Setting for retrieving translations from the OLAP server If you need a specific translation, regardless of the Office display language, you can obtain the translation by adding a property in the Office Data Connection (ODC) file representing the server with the OLAP cube. The default connection string section of the ODC file looks like this: <odc:ConnectionString> Provider=MSOLAP.3; Integrated Security=SSPI; Persist Security Info=True; Data Source=MyOLAPServer; Initial Catalog=Adventure Works DW