Displaying detail and summary data
Typically, a cross tab displays data in a hierarchy. For example, a cross tab might display data by country, state, and city, or by year, quarter, month, and day. Data Analyzer supports drilling up to display higher-level, summary data, or drilling down to display lower-level, detail data. Hiding details, particularly for a cross tab that runs into hundreds of pages, helps you display key information at a glance. The following illustrations show two cross tabs that contain the same data. In Figure 3-38, the cross tab displays the revenue-detail data for cities.
Figure 3-38  
In Figure 3-39, the cross tab hides the details, showing revenue-summary data for each country.
Figure 3-39  
Data Analyzer limits the cross tab page size to approximately 33 MB. Displaying a larger cross tab can freeze the browser. The following message appears if you attempt to display an oversize cross tab page:
Oversize page content can freeze your browser. Open the options dialog to apply page break or open the drill dialog to apply the appropriate filter to reduce its size.
You can hide details to reduce the size of a cross tab. Alternatively, a BIRT iHub System administrator can change the value of the MAX_PAGE_SIZE parameter in web.xml to display a larger cross tab. For more information about modifying web.xml, see Information Console Developer Guide.
Data Analyzer provides the following ways to hide or show detail values:
*
In the structure pane, if more than one hierarchy level appears in Columns or Rows, you can hide the detail values for a level. For example, Figure 3-40 displays country, state, and city levels in Columns. To hide details in the level below state, in the structure pane, right-click State, and choose Hide Detail, as shown in Figure 3-40.
Figure 3-40  
In Figure 3-41, the structure pane and cross tab show country and state levels and hide the city level.
Figure 3-41  
*
Figure 3-42  
The cross tab and the structure pane display detail levels, as shown in Figure 3-43. The cross tab expands the hierarchy levels under Country. This cross tab does not display the countries details for Canada and USA, which the user did not select to appear using the Drill Up Or Drill Down dialog box.
Figure 3-43  
*
Figure 3-44  
*

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2