CONTROL CONSTITUCIONAL DESPUÉS DE LA REFORMA CONSTITUCIONAL DE JUNIO DEL
3.3. La omisión legislativa de reglamentar debidamente el control constitucional
There is another way to drill down, and that is by right-clicking on the bar in question. Right-clicking on a bar opens the context-sensitive menu that displays not only a drill down option, but also a number of other options. These options are displayed in Figure 6-9 and described in Table 6-1.
Table 6-1 mentions that one of the right-click options is Drill Down To. Choosing this option will give you a menu displaying all the dimensions and each dimension can then have a menu showing the levels in that particular dimension hierarchy. Take the standard report that is drilled down to the Product Line level, as shown in Figure 6-9. Each bar represents the total Gross Profit for each Product Line for all time. A simple drill down will drill down on the Product Model Lines hierarchy. The Switch To option will let the user drill down on Date.Calendar. However, what if the user instead wants to find out which sales territories contributed to the gross margin for a particular product line? Neither the Series nor the Bottom Axis have the Sales
Figure 6-8 A report with products in the series and time along the bottom axis. The measure used is placed only in the background.
1 4 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 7Option Functionality
Drill Down This is the same as simply left-clicking on the bar. It takes the user down one level in the hierarchy for the chosen item.
Drill Down To
This is sometimes called cross drilling because it allows the user to drill down on any dimension, not just the dimensions currently in the Series and Bottom Axis. Cross drilling is explained in greater detail later on in the chapter.
Drill Up Drill Up will take the current item and drill up to the previous level in the hierarchy. While drilling down shows only the children of the chosen item, drilling up shows the parent of the chosen items and all its siblings; in other words, it shows all items at the parent level. If the user right-clicks on the first half of 2004 and chooses to drill up, the resulting data are all the members at the Year level, not just the year 2004.
Table 6-1 The Options Available to a User when Right-Clicking on a Bar in an Analytic Report
Figure 6-9 The pop-up menu shows that bars in an Analytic Chart can do more than just drill down.
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y
1 4 9
Option Functionality
Show Only Show Only removes all other items and makes the current bar the only bar on the chart. If the four quarters of a particular year are shown and a user right-clicks on the first quarter and chooses Show Only, quarters two, three, and four disappear from the chart and it is redrawn with only a bar for the first quarter. Remove Remove is the opposite of Show Only. If a user right-clicks on a bar and chooses Remove, that one bar is
removed from the graph while all others remain. This is often useful for eliminating a particularly large or small value, or perhaps all the values listed as unknown.
Switch To <Member>
The Switch To <Member> switches the dimension on which a drill down will occur. In Figure 6-9, the option is Switch To All Periods. Choosing this option and then drilling down on any bar will keep all the Product Lines on the chart, but time will now drill from the All level to the Year level for each product line. This can be seen in Figure 6-10.
Show Details Show Details will execute a Drillthrough action in the cube, often called “drill to detail.” Drillthrough will pull the actual records that make up a particular value. For example, imagine that a user is viewing the sales for a particular product on a particular day. How many individual orders were placed that day? There is no way to tell from the view as described, but using Show Details will show the individual records that contribute to that value. This is useful in many cases, but at high levels there can be millions of records contributing to a number. Fortunately, PerformancePoint will only show the first 1,000 records and give the user a message that there are more available. In addition, this feature only works if the cube designers have created a Drillthrough action. Also, Drillthrough actions only work with regular measures, not calculated measures such as Gross Profit.
Additional Actions
Additional Actions might be built into the cube, and these actions can be tied to members, levels, or an entire dimension. Take, for example, the case where a company is dealing with chemicals. On an individual chemical, an action might exist that launches an internal site that contains information about that chemical, including its safe handling procedures and what to do in the case of accidental exposure. While Show Details will call the Drillthrough action a cube, the actual will also show up here as well, along with any other actions that have been defined.
Sort The Sort option will sort the current data either by the series or bottom axis data. The sort can be from largest to smallest or smallest to largest. In addition, users can remove the sorting here.
Filter Filter allows users to remove empty values from the series, the bottom axis, or both, as well as turn off the filtering of empty values.
Pivot Pivot simply swaps the dimension in the Series with the dimension in the Bottom Axis. If more than one dimension is found in either panel, it does not matter; all dimensions in the Series are swapped with all dimensions in the Bottom Axis. The chart is redrawn accordingly.
Hide/Show Information
The Hide or Show Information option will place a small information bar at the top of the graph or hide it, depending on the current state. Note that in Figure 6-10, a small bar at the top shows that the current measure is Gross Profit. This is useful because nowhere else does the chart indicate the current measure. Not only will measures show here, but if the designer has added filters to the background, such as showing data only for female customers, the information bar would show the measure and “Gender: Female.”
Table 6-1 The Options Available to a User when Right-Clicking on a Bar in an Analytic Report (Continued)
1 5 0
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 7Territory in them. However, the user could right-click on a bar, choose Drill Down To, then select Sales Territory, and finally Country. This will show the gross profit by country for that product line only. This is an important point: the bar on which the user right-clicks acts as a filter, so the resulting data will only be for that product line. This is another case in which having the Show Information option selected is useful. As an example, assume a user right-clicks on the Road product line bar (which is approximately $14.6 million) and chooses Sales Territory and Country. The resulting chart, shown with the Show Information option on, will look like that in Figure 6-11.