REFORMA CONSTITUCIONAL DE JUNIO DEL 2011 SUS ALCANCES Y CONSECUENCIAS
2.1. Los artículos reformados y su repercusión en el control constitucional.
When you are creating a new Analytic Chart, choosing the template from the wizard (or clicking the Analytic Chart button from the Create ribbon) opens the Create an Analytic Chart Report dialog box. This box starts with the same three questions seen on most of the wizards: the name of the report, an optional display folder, and a checkbox asking whether or not all authenticated users should have Read permissions.
Figure 5-25 These are the different report types provided by PerformancePoint Server. These begin to move into the analytics portion of PerformancePoint Server but are created in the Dashboard Designer.
1 1 8
B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7The second page of the wizard asks for the developer to choose a data source, and then the report is created.
Once the report has been generated, the design surface opens in the Design tab in the main work area. In the Details pane is a list of all measures, dimensions, and named sets. Developers can simply drag and drop items from the Details pane and then drop them into the three panels at the bottom of the Design tab, which includes Series, Bottom Axis, and Background. With most typical charts, the bottom axis will represent time and the series will contain one or more measures.
Figure 5-26 shows an example of an Analytic Chart showing the order quantity for eight quarters. The Order Quantity measure has been placed in the Series panel. The Date.Calendar hierarchy has been added to the Bottom Axis panel. After adding the hierarchy, the members have to be selected by the designer. Otherwise only the default member is chosen, which is usually the All member. In order to choose the individual members, developers can right-click on the dimension in the Bottom Axis panel and choose Select Members or click the drop-down indicator to the right of the hierarchy. Either will open up a dialog box which lets the developer expand the
Figure 5-26 An Analytic Chart showing the Date dimension on the bottom axis and the Order Quantity as the series
C h a p t e r 5 : M o n i t o r i n g i n P e r f o r m a n c e P o i n t S e r v e r
1 1 9
various levels of the hierarchy and select any members desired. In this case, the four quarters from each year of 2002 and 2003 were chosen.
Notice that nothing is currently in the Background panel. By default, all
dimensions are always involved in a query, but they typically are defaulted to the All level so they don’t filter the data in any way by default. There are times that reports will need to be filtered by data that is not otherwise displayed as part of the chart or grid. For example, this report could have its name changed to Bikes Quantity Sold and the data could be filtered by bikes. To do this, the Product.Product Categories dimension hierarchy could be placed in the Background panel and then just the Bikes member selected. This would filter the entire report without having to actually display Bikes on the bottom axis or as part of the series.
Once the Analytic Chart has been created, it appears static in the Design pane. However, there is a Browse button that opens the report in a viewer window, and once this is rendered, the report contains some limited interactivity. Specifically, the bars of the chart are live, clickable regions. Clicking on a bar drills down one level in the hierarchy that is placed in the series. Given that in this example, a measure was placed in the Series, there’s no drill down available. However, users can right-click on a bar, choose Drill Down To, and then drill down on any dimension. The user can also basically switch the report from drilling down on the dimension in the series to the one in the bottom axis by right-clicking on a bar and selecting Switch To, followed by the name of the hierarchy. For example, the chart shown in Figure 5-26 has eight bars representing the quarters of 2002 and 2003. If the user uses Switch To in order to select the Time hierarchy, then clicking on one of those bars drills down from that particular quarter to the three months that make up that quarter. Clicking on a bar for the month drills down to the individual days for that month. The drilldown path is determined by the hierarchy structure; in this case, the Date.Calendar hierarchy goes from year to quarter to month to day, so clicking on the bars follows this path of drilling down. There are other capabilities of the Analytic Chart, which will be discussed in Chapter 6 when the analysis piece of PerformancePoint Server is covered.
Creating an Analytic Grid is nearly identical to creating an Analytic Chart. One of the primary differences is that rather than a Series panel, in this case there is a Rows panel. When building charts, it is not uncommon to place both dimensions and measures on the Columns, and other dimensions on the rows. Additional hierarchies can be added to the background if they will be used to filter once this report is added to a dashboard. The Analytic Grid will be discussed in greater detail in Chapter 6.