1 Click the Sales By Country choice in the left-pane Workspace Browser tree list 2 Click the Browse control on the Scorecard design pane 3 Click the Expand and Collapse controls on the Browse Analytic Report

Using Barcode creator for Java Control to generate, create 1D image in Java applications.

dialog box 4 Click OK In Figure 7-26 we re able to click the Browse control to connect to the back-end OLAP cube and interactively drill down through the data This provides a nice design preview capability that helps us see what the end users will see with this analytic grid

Using Barcode generator for Java Control to generate, create Code 128 Code Set B image in Java applications.

Rows field pane Figure 7-27 shows the interactive drag-and-drop capability of the analytic grid, where you can test different cube data elements much as we did with the Scorecard Designer And just as we noted with the Scorecard Designer, you should carefully drag and drop the data elements from the right-side Details tree-view pane into the Rows, Columns, or Background panes to see the blue line that shows where the new data element is going to be positioned in the Rows, Columns, or Background lists

The Background pane is special in two ways: it holds the Measure, which is the numeric data element from the cube that we wish to see displayed in the Grid cells, and whatever data elements are in the Background pane are available as dashboard filter elements Dashboard filters can interactively control the overall display of associated analytics grids and charts if the filter data elements are contained in the Background pane! Figure 7-28 shows how we can browse the grid data with new elements

1 Click the Browse control on the Scorecard design pane 2 Click the Expand and Collapse controls to explore the data in the Browse

Notice in Figure 7-28 that the Browse preview display automatically places the Product Family within the Geography data elements This hierarchical display of data is provided by the very nature of the back-end Analysis Services OLAP cube, and it illustrates the power of scorecards that are constructed in this manner Figure 7-29 shows another feature within the analytic grid; the ability to see the MDX that is being generated behind the scenes

1 Click the Query tab on the Scorecard design-pane top menu 2 Click the desired dimension data element in the right-pane Details tree list 3 Holding down the left mouse button, drag the data element into the MDX query

In Figure 7-29 you see the Multidimensional Expressions (MDX) query that has been automatically generated by our drag-and-drop grid design MDX is the SQL-like query language used to access OLAP cubes, and it was invented by Microsoft as part

7: PerformancePoint: Dashboards, Scorecards, and KPIs

Figure 7-29 PerformancePoint 2007 Reports: analytic grid MDX query

of SQL Server Analysis Services There are many situations in cube data browsing where we d like to see the MDX used to achieve the visual results, and this tool provides just that You can also drag and drop the cube measures and dimensions onto the MDX Query pane itself if you wish, although this is not recommended for anyone that is not fairly expert in MDX syntax

Analytic Chart Design

Figure 7-30 shows off the live-data display feature of the analytic chart, which is very similar to the grid

1 Click the Trailing 8 Quarter Sales by Product selection in the left-pane

3 Holding down the left mouse button, drag the data element into the Scorecard 4 5 6 7

design-pane Series pane Click the Browse control to view the chart Hover the mouse over a line in the chart, and click it to drill down Hover the mouse over a line in the subsequent chart, and click to drill down Click OK

Figure 7-30 shows several design and navigation steps that can be taken with the analytic chart You can drag and drop cube data elements into the Series, Bottom Axis, and Background list panes just as we did with the analytic grid The Background pane is special just as with the grid: it holds the Measure, which is the numeric data element from the cube that we wish to see displayed in the chart, and whatever data elements are in the Background pane are available as dashboard filter elements