Abstract: Techniques for filter sharing are described. An apparatus may comprise a shared filter manager component for an application program. The shared filter manager component may be operative to manage shared filtering operations for the application program. The shared filter manager component may comprise a shared filter interface module operative to receive a selection for a shared filter component to filter multiple source data objects, and assign the shared filter component to the multiple source data objects. The shared filter manager component may further comprise a shared filter control module communicatively coupled to the shared filter interface module. The shared filter control module may be operative to filter data from the multiple source data objects using the shared filter component. Other embodiments are described and claimed.

Abstract: A data analysis program receives a selection of data fields defining multiple row header areas and/or multiple column header areas for display in a summary table. Data is read from a data source containing values for the data fields and transformed into summary level data for building the summary table. A display is rendered in the summary table for each of the multiple row header areas and column header areas defined, with the row header areas being displayed vertically adjacent to one another and the column header areas being displayed horizontally adjacent to one another.

Abstract: A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.

Abstract: A graphical user interface for creating a data summary table includes a data summary table including a plurality of fields, and a filtering pane programmed to apply filters to items in the fields of the data summary table, the filtering pane including a field selector control, wherein the field selector control is programmed to allow for selection of a field of the fields in the data summary table to define filtering for the field.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied.

Abstract: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

Abstract: Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied.

Abstract: Technologies are described herein for allowing a user of an interactive summary table to specify multi-condition data filters to modify the data displayed in the summary table. A user interface is displayed to the user that allows the user to specify a multi-condition data filter. The specification of the multi-condition data filter includes a set of filter conditions connected by logical operators. One or more filter expressions are parsed from the specification of the multi-condition data filter based on the filter conditions and the logical operators, and the filter expressions are applied to the summary data from which the summary table is displayed.

Abstract: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed as well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.

Abstract: A data analysis program receives a selection of data fields defining multiple row header areas and/or multiple column header areas for display in a summary table. Data is read from a data source containing values for the data fields and transformed into summary level data for building the summary table. A display is rendered in the summary table for each of the multiple row header areas and column header areas defined, with the row header areas being displayed vertically adjacent to one another and the column header areas being displayed horizontally adjacent to one another.

Abstract: Techniques for dynamic cross-filtering are described. An apparatus may comprise a filter manager component for an application program. The filter manager component is operative to manage cross-filtering operations for the application program. The filter manager component may comprise a filter control module operative to determine a selection state for a filter data element of a first filter component, and a relationship state for the filter data element of the first filter component with a filter data element of a second filter component. The filter manager component may also comprise a filter interface module communicatively coupled to the filter control module. The filter interface module is operative to dynamically display a different visual indicator for the filter data elements based on the selection state and the relationship state, among other filter criteria or filter states. Other embodiments are described and claimed.

Abstract: Techniques for filter sharing are described. An apparatus may comprise a shared filter manager component for an application program. The shared filter manager component may be operative to manage shared filtering operations for the application program. The shared filter manager component may comprise a shared filter interface module operative to receive a selection for a shared filter component to filter multiple source data objects, and assign the shared filter component to the multiple source data objects. The shared filter manager component may further comprise a shared filter control module communicatively coupled to the shared filter interface module. The shared filter control module may be operative to filter data from the multiple source data objects using the shared filter component. Other embodiments are described and claimed.

Abstract: The present invention relates to a method of manipulating a software application and processing data stored in a data source. The method includes receiving a natural language input and analyze the natural language input to identify semantic information contained therein. Portions of the natural language input are associated with command objects and entity objects of a schema based on the semantic information and the natural language input. The method also includes rendering data from the data source in a table of columns and rows based on the schema and the associated portions of the natural language input.

Abstract: Multiple formulas are associated with a single cell of a spreadsheet. A base formula represents the actual value extracted from a data source. Adjustment formulas represent formulas for calculating adjustments to the value contained within the cell and other formulas can represent different calculation scenarios. Each of the formulas associated with the cell are dynamically updated and adjusted to react to changes elsewhere in the spreadsheet such that a user can recalculate the whole spreadsheet and move formulas around in the spreadsheet causing both the external data formula and all the adjustment formulas that may exist in the same cell to be updated accordingly.

Abstract: A graphical user interface for creating a data summary table includes a pane including a plurality of fields, and a data summary table. Upon selection of a field to include in the data summary table, the user interface is programmed to analyze the field and automatically place the field in the data summary table.

Abstract: According to one aspect, key performance indicators and the accompanying key performance indicator elements may be displayed in a task pane to enable a user to select one or more the key performance indicator elements for use in generating a data summary table. In one example, the key performance indicators of a dataset are identified, and each of the associated key performance indicator elements associated with that key performance indicator is also identified. A key performance indicator may be obtained from any source, including the dataset to which it pertains. Additionally, a name of the identified key performance indicator is determined. The determined name and each of the identified key performance indicator elements are displayed in an organized manner as to enable a user easy selection of the key performance indicator and/or the key performance indicator elements.

Abstract: Generally described, embodiments of the present invention provide the ability to sort and/or filter information contained in a summary table based on related information that may not be included in the summary table. According to one aspect, a computer-readable medium having computer executable components for filtering or sorting information displayed in a summary table is provided. Included in the computer executable medium is a category receipt and identification component configured to receive selections of categories and identify related categories contained in a dataset represented by the summary table. Also included in the computer-readable medium is a filtering component and a sorting component, each configured to control the structure and criteria upon which information contained in a category displayed in the data summary table may be filtered or sorted.

Abstract: The present invention leverages machine learning techniques to provide automatic generation of conditioning variables for constructing a data perspective for a given target variable. The present invention determines and analyzes the best target variable predictors for a given target variable, employing them to facilitate the conveying of information about the target variable to a user. It automatically discretizes continuous and discrete variables utilized as target variable predictors to establish their granularity. In other instances of the present invention, a complexity and/or utility parameter can be specified to facilitate generation of the data perspective via analyzing a best target variable predictor versus the complexity of the conditioning variable(s) and/or utility. The present invention can also adjust the conditioning variables (i.e.