Patent Publication Number: US-7721189-B2

Title: System for and method of providing overview of a worksheet in an electronic report

Description:
CROSS-REFERENCE TO RELATED APPLICATIONS 
     This application claims priority to Canadian Patent Application Serial No. 2,519,003 filed on Sep. 13, 2005. 
     FIELD OF INVENTION 
     The disclosed embodiments relate to a system for and method of providing an overview of a worksheet in an electronic report. 
     BACKGROUND OF THE INVENTION 
     In the Business Intelligence (BI) analysis domain, various data is presented to users in a form of a worksheet, such as a dimensional cross tabulation (crosstab) or a chart. Business analysts needs to be able to manipulate a dimensional crosstab and chart in a variety of ways. Next to seeing the actual values in the crosstab or chart, it is important for the analysts to get feedback on what filter criteria are applied to the displayed data. It is desirable for analysts to be able to get a fast overview of the data shown in a worksheet. 
     Individual filters applied to a dimensional crosstab consist in most cases of one single dimension category, which is called a “member” in Multi Dimensional Expression (MDX). For example, a crosstab can consist of products in the rows, years in the columns and revenue as measure. The values shown for the measure can be filtered using a single category (e.g. region “USA”), using an expression (e.g. where the product values for 1996 is more than 500M) or of a list of selected categories (e.g. a list or order methods: E-mail, Telephone, Mail). The filtering of the values in the crosstab can also be based on a combination of all these types of filters. For a user, it is desirable to easily view, create, update and delete these filter criteria. 
     In a dimensional crosstab, users can have multiple data sets on the rows and/or columns. A data set is a collection of categories from one dimension. On an edge (axis), it is possible to have a combination of multiple data sets. The data sets on such an edge (axis) can come from different dimensions, but also from the same dimension. In the crosstab itself, it is often difficult to see what the structure of the data is. When the crosstab is large, users may have to scroll or navigate to see what is actually in the crosstab. It is desirable for users to easily see what the crosstab structure is, and to be able to manipulate and navigate the data in a small screen real estate solution. 
     Some existing BI tools have a user interface that provides a dimension line or menu where all the dimensions available in the data source are shown. In this type of dimension line, every item is shown at the highest level in the dimension. If a user wants to filter the values on an item (e.g., priority), the user selects the item “Priority” in the dimension line to open a Priority menu and selects a desired category in the Priority menu. The selection of a category changes the values in the crosstab. In the menu, the selected filter is shown highlighted or in bold. This type of menu provides limited options and it is not possible for the users to manipulate the filter criteria further. Showing all dimensions consumes screen real-estate, and it is confusing to the users and makes it difficult to locate a desired dimension. The type of filter that can be shown in the menu is also limited to a single category within a dimension. 
     Another existing prior art shows the data structure near the rows for the row dimensions and near the columns for the column dimensions, and the overall filters in a separate container above or below the crosstab. This approach needs a relatively large screen real estate, and there is no coherence between these elements. 
     It is therefore desirable to provide a mechanism to provide information of crosstab in an efficient manner using a relatively small real estate. 
     SUMMARY OF THE INVENTION 
     The aspects of the disclosed embodiments provide an improved system and method that obviates or mitigates at least one of the disadvantages of existing systems. 
     One aspect of the invention uses an overview area that provides an overview of a worksheet. 
     In accordance with an aspect of the invention, there is provided a worksheet overview system comprising an item information handler, an overview element handler, an overview area handler, and an overview synchronizer. The item information handler is provided for obtaining item information relating to items of a worksheet. The overview element handler is provided for managing overview elements based on the item information, each overview element representing item information of a corresponding item of the worksheet. The overview area handler is provided for providing an overview area for containing the overview elements to make the overview elements contained in the overview area accessible by a user. The overview synchronizer is provided for synchronizing between each overview element in the overview area and its corresponding item of the worksheet. 
     In accordance with another aspect of the invention, there is provided a method of providing an overview of a worksheet. The method comprises obtaining item information relating to items of a worksheet; providing an overview area on a display; presenting one or more overview elements in the overview area based on the item information, each overview element representing item information of a corresponding item of the worksheet; and synchronizing between each overview element in the overview area and its corresponding item of the worksheet. 
     In accordance with another aspect of the invention, there is provided a computer readable medium storing instructions and/or statements for use in the execution in a computer of a method of providing an overview of a worksheet. The method comprises obtaining item information relating to items of a worksheet; providing an overview area on a display; presenting one or more overview elements in the overview area based on the item information, each overview element representing item information of a corresponding item of the worksheet; and synchronizing between each overview element in the overview area and its corresponding item of the worksheet. 
     In accordance with another aspect of the invention, there is provided a propagated signal carrier containing computer executable instructions and/or statements that can be read and executed by a computer, the computer executable instructions being used to execute a method of providing an overview of a worksheet. The method comprises obtaining item information relating to items of a worksheet; providing an overview area on a display; presenting one or more overview elements in the overview area based on the item information, each overview element representing item information of a corresponding item of the worksheet; and synchronizing between each overview element in the overview area and its corresponding item of the worksheet. 
     This summary of the invention does not necessarily describe all features of the invention. 
    
    
     
       BRIEF DESCRIPTION OF THE DRAWINGS 
       These and other features of the invention will become more apparent from the following description in which reference is made to the appended drawings wherein: 
         FIG. 1  is a block diagram showing a worksheet overview system in accordance with an embodiment of the present invention; 
         FIG. 2  is a block diagram showing an embodiment of the worksheet overview system; 
         FIG. 3  is a diagram showing an example of an overview area provided by the worksheet overview system; 
         FIG. 4  is a diagram showing another example of an overview area; 
         FIG. 5  is a diagram showing another example of an overview area; 
         FIG. 6  is a diagram showing another example of an overview area; 
         FIG. 7  is a diagram showing another example of an overview area; 
         FIG. 8  is a diagram showing another example of an overview area; 
         FIG. 9  is a diagram showing another example of an overview area; 
         FIG. 10  is a diagram showing an example of an overview element; 
         FIG. 11  is a diagram showing another example of an overview area; 
         FIG. 12  is a diagram showing another example of an overview area; 
         FIG. 13  is a diagram showing another example of an overview area; 
         FIG. 14  is a diagram showing another example of an overview area; 
         FIG. 15  is a diagram showing another example of an overview area; 
         FIG. 16  is a diagram showing another example of an overview area; 
         FIG. 16A  is a diagram showing another example of an overview area; 
         FIG. 16B  is a diagram showing an example of a combination menu; 
         FIG. 16C  is a diagram showing another example of an overview area; 
         FIG. 16D  is a diagram showing another example of an overview area; 
         FIG. 17  is a diagram showing another example of an overview area; 
         FIG. 18  is a diagram showing another example of an overview area; 
         FIG. 19  is a block diagram showing a properties pane manager; 
         FIG. 20  is a diagram showing an example of a properties pane; 
         FIG. 21  is a diagram showing a part of the properties pane; 
         FIG. 22  is a diagram showing another part of the properties pane; 
         FIG. 23  is a diagram showing another example of a properties pane; 
         FIG. 24  is a diagram showing a part of the properties pane; 
         FIG. 25  is a diagram showing another part of the properties pane; 
         FIG. 26  is a diagram showing another part of the properties pane; 
         FIG. 27  is a diagram showing another example of a properties pane; 
         FIG. 28  is a diagram showing a part of the properties pane; 
         FIG. 29  is a diagram showing another part of the properties pane; 
         FIG. 30  is a diagram showing another example of a properties pane; 
         FIG. 31  is a diagram showing another example of a properties pane; 
         FIG. 32  is a diagram showing an example of sort options; 
         FIG. 33  is a diagram showing another example of a properties pane; 
         FIG. 34  is a diagram showing another example of a properties pane; 
         FIG. 35  is a diagram showing another example of a properties pane; 
         FIG. 36  is a diagram showing another example of a properties pane; 
         FIG. 37  is a diagram showing another example of a properties pane; and 
         FIG. 38  is a diagram showing another example of a properties pane. 
     
    
    
     DETAILED DESCRIPTION 
       FIG. 1  shows a computer system  2  in which a worksheet overview system  20  is suitably used. The computer system  2  has an input unit  4  and an output unit  6 . The worksheet overview system  20  suitably works with or within a data analyzing system  10 , such as a business intelligence tool, that provides views or reports of data stored in one or more data sources  8 . The worksheet overview system  20  manages an overview of a worksheet in a report generated by the data analyzing system  10 .  FIG. 1  exemplifies that the data analyzing system  10  is running on a single computer system  2 . In a different embodiment, the data analyzing system  10  may be running on a computer unit that is part of a server-client system or any other computer system. 
     The data analyzing system  10  has a user interface  12  to receive user inputs through the input unit  4 , and presents generated reports and other information to users through the output unit  6 . The data analyzing system  10  is capable of generating reports containing a worksheet, such as a crosstab or a chart. 
     The worksheet overview system  20  typically works with or through the user interface  12  of the data analyzing system  10 . The worksheet overview system  20  provides an overview area that presents an overview of a worksheet. An overview of a worksheet is a summary description of parts or items that constitute the current state of the worksheet. The worksheet overview system  20  allows users to use the overview area to interact with items of the worksheet and manipulate them, as further described below. 
     The overview area is a container for containing overview elements or icons. An overview element represents a summary description or information of one or more items (data sets) of the worksheet. 
     As shown in  FIG. 2 , the worksheet overview system  20  has an item information handler  30 , an overview area handler  40 , an overview element handler  50 , and an overview synchronizer  60 . 
     The item information handler  30  manages information of items of the worksheet. The item information handler  30  obtains information regarding the items of the worksheet from the underlying data source or sources  8  or a metadata model that the report generating system  10  uses to generate reports for the data sources  8 . The item information handler  30  has a row information handler  32 , a column information handler  34 , and a context information handler  36 . When the worksheet overview system  20  deals with a crosstab, the row information handler  32  obtains information regarding one or more row data sets of the crosstab. Similarly, the column information handler  34  and the context information handler  36  obtain information regarding one or more column data sets and context of the crosstab, respectively. Context information includes filter criteria and/or other conditions applied to the crosstab as a whole. 
     The overview area handler  40  provides an overview area. Items of the worksheet are typically grouped according to the structure of the worksheet. The overview area handler  40  divides an overview area into multiple sections to correspond to the structural grouping of the items of the worksheet. For example, items of a crosstab are grouped by rows, columns and overall context. Thus, for a crosstab, the overview area has a row information section, a column information section, and a context information section. 
     The overview area handler  40  presents the overview area at a location on the screen of the output unit  6  where the overview area is easily seen by the user when its associated worksheet is fully or partially displayed. The overview area may be located above the worksheet below the toolbar on the screen. 
     The overview element handler  50  manages the presentation of overview elements, or icons. Each overview element represents information of one or more items of the worksheet. The overview element handler  50  uses the information obtained by the item information handler  30  to manage the presentation of overview elements. Also, it changes the presentation of overview elements depending on user&#39;s actions on the overview elements. When the worksheet is a crosstab, the item information handler  30  obtains information of row items, column items and context items of the crosstab. The overview element handler  50  presents overview elements representing row items in the row information section based on the information obtained by the item information handler  30 . Similarly, the overview element handler  50  presents overview elements representing column items in the column information section, and overview elements representing context items in the context information section. 
     The overview element handler  50  provides each overview element with an item label indicating which item of the worksheet the overview element represents. The overview element handler  50  may provide an overview element having a menu for indicating details of the item information that the overview element represents and/or available options relating to the corresponding item or items of the worksheet. The overview element handler  50  allows the user to open and close the menu and select one or more desired options from the menu to act on the corresponding items in the worksheet, without actually accessing the items in the worksheet, as further described below. 
     The overview element handler  50  may provide a movable overview element, and allow the user to move the movable overview element between different sections in the overview area by using, e.g., a dragging and dropping action. 
     The overview element handler  50  allows users to manipulate overview elements in the overview area, such as creating or inserting new overview elements and modifying, interacting and deleting existing overview elements. 
     The overview synchronizer  60  handles synchronization between overview elements in the overview area and the corresponding items in the worksheet. When a worksheet is created, the overview synchronizer  60  obtains information relevant to the items of the worksheet using the overview element handler  50 , and presents, in the overview area, overview elements representing the obtained item information using the overview element handler  50 . 
     When the worksheet is changed, the overview synchronizer  60  reflects the changes to overview elements in the overview area through the overview element handler  50 . 
     When the user changes overview elements in the overview area, the overview synchronizer  60  reflects the changes to the corresponding items of the worksheet. The changes made to the worksheet also changes the data in the overview area accordingly. 
     For example, when the user creates a new overview element in a row information section, the overview synchronizer  60  causes the data analyzing system  10  to add to the crosstab a new row data set that corresponds to the new overview element in the overview area. When the user deletes an overview element from a column information section in the overview area, the overview synchronizer  60  causes the corresponding column data set to be deleted from the crosstab. When the user selects an option, e.g., drilling up or down a hierarchy of items or searching an item, from the menu on an overview element in the overview area, the overview synchronizer  60  causes the crosstab to reflect the selection to show, e.g., drilled results or search results. When the user drags a movable overview element, e.g., from a row information section to a column information section, the overview synchronizer  60  causes the crosstab to change the row data set represented by the overview element into a column data set. 
     By creating overview elements in the overview area, the user may create a new worksheet. 
     The overview synchronizer  60  determines what information is relevant to the current status of the worksheet, and presents overview elements that represent the information relevant to the current status of the worksheet. For example, the overview synchronizer  60  causes the overview element handler  50  to present, in the context information section, overview elements representing the filters that are applied to the underlying worksheet, rather than showing a list of all filters which may or may not be applicable to the current status of the worksheet. 
     Thus, the worksheet overview system  20  presents in the overview area representations of the items in the worksheet, which assist users to understand what items make up the worksheet. This is especially advantageous when the worksheet is larger than the display area for the worksheet on the screen, and actual worksheet items represented by the overview elements are out of the view and cannot be seen without scrolling. 
     The worksheet overview system  20  allows users to interact on structural items that make up the worksheet through interacting with the overview elements in the overview area. As overview elements represent high-level items of the worksheet, the interaction (e.g. drill, search) with overview elements, is often easier and more intuitive for users than searching, selecting and acting on actual items or objects in the worksheet. 
       FIG. 3  shows an example of an overview area  100  presented by the overview system  20  for a crosstab  120 . In this example, the overview area  100  is presented just above the associated crosstab  120 . The overview area  100  has a row information section  102 , a column information section  104  and a context information section  106 . 
     The row information section  102  is provided to contain one or more overview elements that represent information of one or more row data sets of the crosstab. The column information section  104  is provided to contain one or more overview elements that represent information of one or more column data sets of the crosstab. The context information section  106  is provided to contain one or more overview elements that represent information of the context of the crosstab, e.g., information of filters and other contextual conditions of the crosstab. 
     The overall area  100  is dimensioned compact enough so that it can be kept visual on the screen when the entire or a part of associated crosstab is displayed. The information sections  102 ,  104  and  106  may be resizable individually or as a whole. The overall area  100  may provide movable partitions  108  between the information sections  102 ,  104  and  106 . Each information section  102 ,  104 ,  106  may become scrollable when there are multiple overview elements in order to save the screen real estate. In this example, the information sections  102 ,  104  are  106  arranged in line to form a one-line overview area  100 . In a different embodiment, the information sections  102 ,  104  and  106  may be arranged differently. 
     By using the overview area  100 , the overall structure of the crosstab is captured in a single compact overview area, while providing separation of the information for the rows and columns from the context information. 
     In this crosstab  120 , the rows are provided for dimension “Line” containing Dishwashers, Stoves and Microwaves as categories. Line is the parent category. The columns are provided for dimension “Date” containing 1993 and 1994 as categories. Date is the parent category. The values are shown for measure “Revenue”. 
     For this crosstab  120 , the overview system  20  provides the overview area  100  with two overview elements  110 . One overview element  110  is labeled “Line” and presented in the row information section  102 . The other overview element  110  is labeled “Date” and presented in the column information section  104 . The context information section  106  is not filled out as currently there are no filters applied to the data shown in the crosstab  120 . 
     When the user wants to filter the data in the crosstab  120  for the revenue in New York only, the user inserts a location category “NY” as a filter in the context information section  106 , as shown in  FIG. 4 . Typically, the data analyzing system  10  provides a list or tree of categories, dimensions and/or measures available to create reports for the underlying data source or sources  8 . The user may select Location “NY” from the list or tree, and drag and drop the NY item  112  into the context information section  106 . In response to the insertion of the filter, as shown in  FIG. 5 , the overview element handler  50  creates a new overview element  114  in the context information section  106 . The new overview element  114  is labeled “NY”. The values in the crosstab  120  are also changed since the crosstab  120  now has a contextual filter “NY” applied to it. 
     The overview system  20  provides one or more menus through overview elements  110  in the overall area  100 . Menus present available options to act on items in the crosstab  120  from the overview area  100 , without the need to interact directly with the items in the crosstab  120 . For example, as shown in  FIG. 6 , the user can select an arrow down button  130  of the overview element  110  labeled “Line” in the row information section  102  of the overview area  100  to open a menu  132 . The menu  132  shows options available for the row items Line. By selecting a desired option, e.g., Microwaves, from the menu  132 , the user is able to drill down on Microwaves. The selected items and corresponding overview elements become highlighted in the crosstab  120  and in the overview area  100  in synchronization. 
     The dropdown menu  132  is typically used to present options for the main functionality for the item represented by the overview element  110  in the overview area  100 , such as categories shown in the crosstab  120  and filtering and navigation within the data. The overview system  20  may provide a different menu or an additional menu or menus. For example, as shown in  FIG. 7 , the overview system  20  may provide a context menu  134  showing options for other interactions, e.g. sort, top/bottom rule, and calculations. The context menu  134  may be invoked by, e.g., right-mouse clicking. The context menu  134  may be same as the menu available in the crosstab  120 . 
     The user may select an overview element  110  by clicking on an item of the overview element  110 . A movable overview element may have a handle, e.g., a dotted area  136  in  FIG. 7 , to indicate that the user can select and move the overview element. 
     The overview system  20  allows the user to perform nesting of items using overview elements in the overview area  100 . For example, as shown in  FIG. 8 , the user can drag an item “Market”  140  from a list of dimensions or items into the row information section  102  after the existing overview element  110  labeled “Line”. After insertion, as shown in  FIG. 9 , a new overview element  112  labeled “Market” is created in the row information section  102  in the overview area  100 , and the crosstab  120  is changed in synchronization to nest the market rows in the line rows. In this example, the market rows are for Builders, Furniture, Department Rental and Home. 
     The overview system  20  also allows replacement of items in the overview area  100  by drag-and-drop actions. As shown in  FIG. 10 , an item Date  114  highlighted in the columns may be replaced with item Department  116 . 
     When one of the item sets in the crosstab  120  is filtered with an expression, the overview system  20  decorates the corresponding overview element  110  with a filtering symbol  150  representing that it is filtered, as shown in  FIG. 11 . 
     When the filtered row element  110  is moved to the context information section  106 , the expression of the filter becomes a contextual filter that changes the data in the entire crosstab  120  such that all data in the crosstab  120  is filtered according to the expression. For example, as shown in  FIG. 12 , when the user moves overview element “Line”  110  with a filter  150  from the row information section  102  to the context information section  106 , the filter  150  of the line is applied to the entire crosstab  120 . The crosstab  120  now shows the Market categories as rows without nesting. 
     An item in the crosstab may consist of a list of items, instead of a parent category with its children categories as shown in the examples above. As shown in  FIG. 13 , the overview system  20  may add a term “list”  160  to an overview element  112  in the overview area  100  that represents an item consists of a list of items. 
     As demonstrated above with examples, the overview system  20  maintains a visual synchronization between the overview area  100  and the crosstab  120 . 
     When there are too many overview elements in the rows, columns or context information sections  102 ,  104  and  106 , the overview system  20  provides the ability to scroll in the overview information section  102 ,  104  or  106 . The user can scroll the relevant information section  102 ,  104  or  106  using, e.g., arrow buttons  170  as shown in  FIG. 14 . 
     In addition to having the filter icon in front of an overview element label, the overview system  20  may show other icons to indicate what kind of functions are applied to that data set in the crosstab. Examples of functions include sorting and calculations. The example below shows the sorting function. 
     When sorting is applied to an item of the crosstab  120 , the overview system  20  may indicate the application of the sorting using a set of arrows  172  in the corresponding overview element  110 , as shown in  FIG. 15 . 
     Movable overview elements can be moved from one location in the overview area  100  to another, without the need to interact in the crosstab. As shown in  FIG. 16 , item Market can be moved from the rows to columns in the crosstab  120  by dragging the “Market” overview element or icon  112  from the row information section  102  to the column information section  104  in the overview area  100 . The item being dragged may be represented by a ghosted element  118  near a mouse cursor  190 . 
     The overview system  20  may also handle a case of a “union” in the row axis or the column axis.  FIG. 16A  shows an example of a crosstab  120  having a union in the row axis. In this case, the overview system  20  may represent the union by using a label “Combination” on the relevant overview element  162  in the row information section  102 . The overview element  162  may also be made movable. As shown in  FIG. 16B , a dropdown menu  164  for the combination overview element  162  may show two different data sets, Products and Locations, in this example. From this menu  164 , the user may select a data set to open cascading menus  166  to delete or modify the settings of the union of the selected data set, as shown in  FIG. 16C . The cascading menus  166  typically show the same options as those for overview elements that are not combined. The overview system  20  may also provide overview elements representing a combination nested with another data set.  FIG. 16D  shows an example of an overview area for a crosstab  120  in which a combination Channels nested in the Products. The overview system  20  presents an overview element  168  labeled “Channels” next to the combination overview element  162  in the row information section  102 . 
     As shown in  FIG. 17 , the overview system  20  may keep the overview area  100  visible when a chart  180  is shown in place of the crosstab. Showing the overview area  100  for the chart  180  prevents the need to learn another interaction model within the crosstab to change the data definition. 
     As exemplified above, the overview system  20  provides an overview area that provides an overview of items that make up the structure of a crosstab or chart. The overview area is compact enough to be presented together with the entire or a part of a crosstab or chart. Typically the overview area has one line or a few lines of overview elements arranged in multiple sections to represent the structure of the underlying crosstab or chart. The arrangement of overview elements may vary depending on the display design of the data analyzing system  10  with which the overview system  20  works. The overview system  20  provides a direct mapping between the selection in the overview area  100  and the selection in the crosstab or chart by synchronization in both directions. 
       FIG. 18  shows another example of an overview area  100 . This example shows a link  202  to a property pane. 
     The overview system  20  may work with a properties pane manager  220  as shown in  FIG. 19 . Selecting the link  202  shown in  FIG. 18  invokes the properties pane manager  220 . The properties pane manager  220  may be also invoked from items in a worksheet or from a menu item at the top of the application. 
     The properties pane manager  220  provides a properties pane that shows properties of a selected item in a worksheet, e.g., selections and conditions applied to the selected item. The properties pane provides a quick and clear overview of the functionality applied to the selected item. 
     The properties pane handler  220  allows users to manipulate the properties of the item in the properties pane. This manipulation gives the users an ability to fine-tune their queries to answer the correct business questions. 
     The overview synchronizer  60  of the worksheet overview system  20  also synchronizes the properties pane handler  220 . For example, when the user selects a data element in the worksheet overview system  20 , the properties pane of the selected data element is also synchronized. The overview synchronizer  60  maintains synchronization among the worksheet, overview area, and properties pane. 
       FIG. 20  shows an example of a properties pane  230 . The user opens the properties pane  230 . When nothing is selected in the crosstab  120 , the properties applicable to the entire crosstab  120  are shown in the properties pane  230 . 
     The property pane  230  has a title bar  232  that reflects the name of the dimensional member associated with the selected item in the crosstab  120 , or in the absence of a selection, the title bar  232  reflects the name of the analysis and/or the report title assigned by the user. 
     In this example, the property pane  230  shows the current properties of the entire crosstab relating to a default measure, rows, columns context and report options. 
     The default measure properties section indicates the currently selected measure and how the values are shown. The default measure properties section provides users with the ability to change these selections. When the user selects the current measure Revenue, a dropdown menu is opened to present a list of available measures, as shown in  FIG. 21 . When the user selects the show values selection, a dropdown menu is opened to present a list of available show values options, as shown in  FIG. 22 . 
     The rows properties section shows the name or names of the existing data sets in the rows of the crosstab. The user can click it, which will result in the selection of that item and showing the properties of that data set. 
     The columns properties section is similar to the rows properties section and shows the name or names of the existing data sets in the columns of the crosstab. The user can click it, which will result in the selection of that item and showing the properties of that data set. 
     The context properties section shows the filters that apply to the data values in the crosstab. If there is an expression, the context properties section shows the expression as full description. If there are multiple expressions and filters, the context properties section enumerates the multiple expressions in a continuous line (which can wrap as well) 
     The report options properties section shows the default options from a report options setting dialog. The user can modify these options by clicking on an overview element and navigate into the report options dialog. 
       FIG. 23  shows another example of a properties pane  240  when a different type of item or object is selected within the crosstab  120 , e.g. “Line”. The properties pane  240  has properties sections for display, definition, filter, context and sort. 
     The display properties section shows the properties that indicate what settings are set that influence the display of the selected data set. Some examples are shown in  FIGS. 24 and 25 . If the user wants to hide an item (e.g. Stoves) in the data set in the crosstab, the “No hidden items” is changed into “Hidden Items ( 1 )”, as shown in  FIG. 26 . The line for the “Display” may not stay in the same location when the text is longer. It may wrap to the next line as shown in  FIG. 27 . 
     The “Definition” line provides a specific selection of how the expression/definition for the selected data set will behave when the crosstab changes. 
     The filter, context and sort properties sections are related to how the “query” is behaving. 
     In the filter properties section, as shown in  FIG. 28 , the user may change “No top or bottom” to, e.g. “Top” and then, the user may immediately override the default value for the top  10  as shown in  FIG. 29 . The user may change “No expression” into a specific expression. When the user selects the edit overview element or the text itself, a dialog for the filter expressions appears for the user to create or edit the filter expression. Once the filter expression is created, the text in the filter properties section is updated, as shown in  FIG. 30 . 
     After the user changed the value of a certain property, that value is highlighted or bolded to indicate that the property value has been changed from its current setting. Changes to the properties is applied when an OK or Apply button is selected. This allows a number of property values changes to be made collectively, and applied once. This is an advantageous capability in a zero-footprint web application to minimize the number of server roundtrips required. 
       FIG. 31  shows an example of the selection of a data set later in the analysis process. 
     The data set “State” has a description of an expression filter for Context. This item fits in the properties pane. If an item has a longer description, the description is wrapped to a next text line so that the full text for the description can be shown. 
     The sort properties section provides a means to show what kind of sort is applied to the selected item. The user can interact with it to change the sort direction and on what can be sorted, as shown in  FIG. 32 . 
       FIG. 33  shows an example of a properties pane for an individual category (member).  FIG. 33  shows an example of a properties pane for a measure.  FIG. 34  shows an example of a properties pane for an intersect value.  FIG. 35  shows an example of a properties pane for a context filter.  FIG. 36  shows an example of a properties pane for another type of set that has the properties of name, expression and definition.  FIG. 37  shows an example of a properties pane for an item that has properties of display, context and sort.  FIG. 38  shows an example of a properties pane for an item that has properties of display, filter, context and sort. 
     The properties pane manager  220  provides a properties pane for a selected item in the crosstab, with a text that is descriptive and easy to read to show what functions are applied to the selected item. The properties pane manager  220  provides the ability to interact with this functionality directly, without the need to invoke the function elsewhere. Because the text is descriptive and easy to read, business users can understand the fine-tuned applied functionality to elements of a report. The properties pane manager  220  also provides an interactive “footnote” idea to a selected item. It is possible to modify multiple functions at once, without applying it to the crosstab immediately. Within a properties pane, the properties pane manager  220  provides the ability to select another object available in the crosstab, and have also the properties shown for that object. The properties pane manager  220  can provide a combination of properties that is unique for a selected data set in a crosstab. The properties pane manager  220  allows wrapping of a long text in a properties pane. The properties pane manager  220  provides a properties pane that is a compact way to change settings of a crosstab or element of a crosstab and functions. The interaction with the individual properties is a part of the text. When the network connection is slow, it is useful for the end user to perform multiple actions in one submission, instead of having to submit each individual action. When the crosstab is large, there may also be a performance hit, since rendering the crosstab takes some time for a large crosstab. The properties pane manager  220  allows the user to perform multiple actions in one submission, which prevents a long waiting time. 
     The worksheet overview system of the invention may be implemented by any hardware, software or a combination of hardware and software having the above described functions. The software code, instructions and/or statements, either in its entirety or a part thereof, may be stored in a computer readable memory. Further, a computer data signal representing the software code, instructions and/or statements may be embedded in a carrier wave may be transmitted via a communication network. Such a computer readable memory and a computer data signal and/or its carrier are also within the scope of the present invention, as well as the hardware, software and the combination thereof. 
     While particular embodiments of the invention have been shown and described, changes and modifications may be made to such embodiments without departing from the scope of the invention. For example, the elements of the worksheet overview system are described separately, however, two or more elements may be provided as a single element, or one or more elements may be shared with other components in one or more computer systems.