Drill By

 < Day Day Up > 



Using the same pop-up menu, you can also select Drill By to explore data by other dimensions that exist in the document or microcube but that are not currently displayed in the report. In the following pop-up menu, Varietal and Vintage are additional columns of information that one can Drill By without generating a new query. Selecting Drill By to Varietal produces the same results as drilling down from Color to Varietal. However, setting Drill By to Vintage creates an entirely new perspective on the data. BusinessObjects will automatically move the current column to the Drill toolbar and replace it with the Drill By column.

With the Drill By Vintage, you can see that there are a few fairly old, very high-priced, French, Bordeaux Blend, Red wines that will affect the average price.

click to expand

The Drill By is contextual and becomes more powerful when more details and columns of data are available in the microcube but not displayed in the report. For example, the EFASHION universe contains three classes: Store, Product, Time Period. A user can start by analyzing Sales revenue at the top level for each of these dimensions. If all the details for each dimension are included in the query, then the Drill By displays these additional levels, as shown in the following screen. When a user Drills By State from the Store class, you can drill to the next level of City or to the lowest level of detail, Store name.

When you select Drill By from the Product dimension or Lines column, then the pop-up menu changes to reflect additional columns of data and levels of detail. BusinessObjects groups the variables by class or hierarchy and sorts the variables from biggest to smallest within the hierarchy. The “Hierarchy Editor” section later in this chapter describes how you can customize this.

click to expand

The Drill By pop-up menu will display only a few lines of available dimensions. You can elect to display more dimensions by changing your Drill options (Tools | Options, Drill tab). When more dimensions or levels of detail are available, select More to display the Drill By – All Available Dimensions dialog box. Within the dialog box, dimensions currently displayed in the report appear dimmed. All other variables that exist in the document appear in the Drill By list and appear in a regular font. The universe may contain still more columns by which to explore the data; however, if they do not exist in the local document, Drill By does not display them. Scope of Analysis and Drill Through do.



 < Day Day Up > 



Business Objects(c) The Complete Reference
Cisco Field Manual: Catalyst Switch Configuration
ISBN: 72262656
EAN: 2147483647
Year: 2005
Pages: 206

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net