Dynamically filtering aggregate reports based on values resulting from one or more previously applied filters
First Claim
1. A computer-implemented method for dynamically filtering aggregate reports based on visible values in the aggregated reports, the method comprising:
- a) maintaining a plurality of filters to be applied in a designated order to the aggregated reports, wherein the each of the aggregated reports comprises a plurality of fields for displaying report details, wherein the report details are collapsible within each of the plurality of fields causing the report details to be hidden;
b) applying, by the computer, a first filter to an original aggregate report, wherein the first filter is applied to the original aggregate report only when the report details for at least one of the plurality of fields are hidden with respect to other report details which are displayed within at least one other field within the plurality of fields;
c) evaluating values of the original aggregated report based on the first filter therein producing an intermediate filtered aggregate report, wherein evaluating values of the original aggregated report comprises filtering inner nested fields based on visible values for a corresponding outer nested field;
d) applying a next filter to the intermediate filtered aggregate report; and
e) evaluating visible values of the intermediate filtered aggregate report based on the next filter therein producing a next filtered aggregate report, wherein evaluating visible values comprises aggregating totals from applying the first filter and using the totals aggregated as inputs for aggregating totals from applying the next filter and wherein evaluating visible values of the intermediate aggregated report also comprises filtering inner nested fields based on visible values for a corresponding outer nested field.
2 Assignments
0 Petitions
Accused Products
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.
53 Citations
17 Claims
-
1. A computer-implemented method for dynamically filtering aggregate reports based on visible values in the aggregated reports, the method comprising:
-
a) maintaining a plurality of filters to be applied in a designated order to the aggregated reports, wherein the each of the aggregated reports comprises a plurality of fields for displaying report details, wherein the report details are collapsible within each of the plurality of fields causing the report details to be hidden; b) applying, by the computer, a first filter to an original aggregate report, wherein the first filter is applied to the original aggregate report only when the report details for at least one of the plurality of fields are hidden with respect to other report details which are displayed within at least one other field within the plurality of fields; c) evaluating values of the original aggregated report based on the first filter therein producing an intermediate filtered aggregate report, wherein evaluating values of the original aggregated report comprises filtering inner nested fields based on visible values for a corresponding outer nested field; d) applying a next filter to the intermediate filtered aggregate report; and e) evaluating visible values of the intermediate filtered aggregate report based on the next filter therein producing a next filtered aggregate report, wherein evaluating visible values comprises aggregating totals from applying the first filter and using the totals aggregated as inputs for aggregating totals from applying the next filter and wherein evaluating visible values of the intermediate aggregated report also comprises filtering inner nested fields based on visible values for a corresponding outer nested field. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer program product comprising a computer-storage medium having control logic stored therein for causing a computer to dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report, the control logic comprising computer-readable program code for causing the computer to:
-
a) maintain a collection of filters to be applied in a designated evaluation order to the aggregate report, wherein the aggregate report comprises a plurality of fields for displaying report details, wherein the report details are collapsible within each of the plurality of fields causing the report details to be hidden; b) apply a first filter to the aggregate report, wherein the first filter is applied to the aggregate report only when the report details for at least one of the plurality of fields are hidden with respect to other report details which are displayed within at least one other field within the plurality of fields; c) evaluate aggregate values in the aggregate report based on the first filter therein producing aggregate values in the aggregate report resulting from applying the first filter, wherein evaluate aggregate values of the aggregate report comprises filtering inner nested fields based on visible values for a corresponding outer nested field; d) apply a next filter to the aggregate report; and e) based on the next filter, evaluate the aggregate values in the aggregate report resulting from any filters previously applied therein producing aggregate values in the aggregate report resulting from applying the next filter, wherein the evaluation based on the next filter comprises aggregating totals from applying the first filter and using the totals aggregated as inputs for aggregating totals from applying the next filter and wherein evaluate the aggregate values of the aggregate report comprises filtering inner nested fields based on visible values for a corresponding outer nested field. - View Dependent Claims (12, 13, 14)
-
-
15. A computer-implemented method for dynamically filtering an aggregate report based on values resulting from one or more filters previously applied to the aggregate report, the method comprising:
-
a) maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, wherein the aggregate report comprises a plurality of fields for displaying report details, wherein the report details are collapsible within each of the plurality of fields causing the report details to be hidden; b) applying, by the computer, a filter to the aggregate report, wherein the filter is applied to the aggregate report in response to hiding the report details displayed within at least one of the plurality of fields; c) based on the filter, evaluating aggregate values in the aggregate report to produce aggregate values resulting from applying the filter, wherein evaluating aggregate values of the aggregate report comprises filtering inner nested fields based on visible values for a corresponding outer nested field; d) applying another filter to the aggregate report; and e) based on the another filter, evaluating the values in the aggregate report resulting from applying the filter therein aggregating the aggregate values resulting from applying the another filter, wherein evaluating the values based on the another filter comprises aggregating totals from applying the filter and wherein evaluating the values in the aggregate report based on the another filter also comprises filtering inner nested fields based on visible values for a corresponding outer nested field. - View Dependent Claims (16, 17)
-
Specification