Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 829

Figure 15-53
6. Data Analyzer now retrieves the data from the Analysis Services in-
stance with the help of several MDX queries, and you will see a view
in your Data Analyzer as shown in Figure 15-54 . Members within a
hierarchy are indicated using bars and the length of the bar is de-
termined based on the Internet sales amount. You can see that Un-
ited States has a bar that has the maximum length closely followed
by Australia. This allows you to easily infer that Internet sales in the
United States are at least three times the sales in Germany. The
visual indication really helps the analysts to capture the information
quickly. In addition to that you see the Internet Sales not only based
on the customer's geography, but also on various other dimensions
such as Calendar and Product category. If you click a specific mem-
ber, United States, in a customer geography hierarchy you will notice
that that member gets highlighted ( Figure 15-55 ) . In addition to that,
the length of the bars on other dimensions automatically changes be-
cause those bars now represent the data corresponding to the Un-
ited States. Hover over the member United States to get the Internet
Sales Amount as shown in Figure 15-55 .