Database Reference
In-Depth Information
Figure 11-47.
Reviewing the KPI results
■
A cube must be processed before Visual Studio can display the results. The reason for this is that the
data is not derived from the XML files in Visual Studio but rather from the database on your SSAS server. Notice that
the Reconnect button is available on the KPi tab just as it is on the cube browser tab. You can use this to reconnect
to your server after the cube has been processed.
Important
The number 493 is greater than 25 to 50; therefore, the status indicator is an upward-pointing arrow. This
particular result is somewhat meaningless, because what we would really like to see is how a particular title fared
within that sales quantity range. To adjust this, we need to filter out the value that we want to test from the cube.
We can do this by defining the dimension hierarchy operator and filter expression just above the results pane, as
shown in Figure
11-48
. Each of these columns holds a dropdown box allowing you to choose which item to use.
By selecting a dimension hierarchy operator and a particular title, we can see what category of sales quantity that
particular title falls under.
Figure 11-48.
Filtering the KPI results
