Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

134

❘

LESSON 15 Editing Your CubE

The next tab is the

 ➤

Translations tab, which is not nearly as handy as it may appear at first. In

this tab you can translate your measures and measure group names to nearly any language.

When users connect to the cube, they can pass in their languages in the connection string;

some browsers automatically detect a user’s locale from Windows. SSAS will then return the

measures and measure group names in the users’ native languages. You can also perform a

translation in each dimension to translate the attribute names and member names. The prob-

lem is that your data must support it with a new column like SpanishMonthName that SSAS

will read from for member names. For attribute and measure names, you must enter the new

translations manually.

The last tab, the Browser tab, is covered in the next section of this lesson.

BROWSING THE CUBE

The Browser tab in the Cube Editor will let you view the data of your cube and slice and dice it by

the dimensions. Prior to using it, make sure any changes to your cube have been deployed by going

to Build  ➪  Deploy <Project Name>. Once a deployment happens, you’ll need to reconnect to the

cube on the server by clicking the Reconnect icon on the top left icon bar.

As you can see in Figure 15-6, you start with a blank slate in the right pane. In the left pane, you can

expand Measures to see a list of measures you can ...