System and method for analyzing data in a report
First Claim
Patent Images
1. A method comprising:
- identifying a cross-tab intersection in a cross-tab;
retrieving a data source for a structured report;
collecting a context for the cross-tab intersection in the data source, wherein the context includes a data value;
building an analysis specification, with a processor, based on the collected context byextracting a slicer from the structured report and adding the slicer to the analysis specification based upon the structured report having said slicer,extracting a member of one or more master-detail pages and adding the one or more master-detail pages to the analysis specification based upon the structured report having one or more master-detail pages,extracting a default measure from the structured report and adding the default measure to the analysis specification based upon the structured report having a default measure, andadding at least one child of the member to the analysis specification based upon the member being an innermost nested member; and
analyzing, with an analysis tool, the cross-tab intersection using the analysis specification.
4 Assignments
0 Petitions
Accused Products
Abstract
A method and a system for analyzing a data value of interest in a multidimensional database. The data value of interest is first identified in a structured report. The data source for the structured report is retrieved. A context for the data value of interest in the data source is collected, for example, by extracting a slicer from the structured report, by extracting members of master-detail pages, or by extracting a default measure from the structured report. An analysis specification based on the collected context is then built, and the data value of interest is analyzed using the analysis specification. The result from analyzing the data value of interest may be presented in an analysis view.
-
Citations
22 Claims
-
1. A method comprising:
-
identifying a cross-tab intersection in a cross-tab; retrieving a data source for a structured report; collecting a context for the cross-tab intersection in the data source, wherein the context includes a data value; building an analysis specification, with a processor, based on the collected context by extracting a slicer from the structured report and adding the slicer to the analysis specification based upon the structured report having said slicer, extracting a member of one or more master-detail pages and adding the one or more master-detail pages to the analysis specification based upon the structured report having one or more master-detail pages, extracting a default measure from the structured report and adding the default measure to the analysis specification based upon the structured report having a default measure, and adding at least one child of the member to the analysis specification based upon the member being an innermost nested member; and analyzing, with an analysis tool, the cross-tab intersection using the analysis specification. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A system comprising:
-
a processor configured to; identify a cross-tab intersection in a cross-tab; retrieve a data source for a structured report; collect a context for the cross-tab intersection in the data source, wherein the context includes a data value; build an analysis specification based on the collected context by extracting a slicer from the structured report and adding the slicer to the analysis specification based upon the structured report having said slicer, extracting a member of one or more master-detail pages and adding the one or more master-detail pages to the analysis specification based upon the structured report having one or more master-detail pages, extracting a default measure from the structured report and adding the default measure to the analysis specification based upon the structured report having a default measure, and adding at least one child of the member to the analysis specification based upon the member being an innermost nested member; and analyze, with an analysis tool, the cross-tab intersection using the analysis specification. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A non-transitory storage medium readable by a computer encoding a computer program for execution by the computer to carry out a method for analyzing a data value of interest in a multidimensional database comprising:
-
identifying a cross-tab intersection in a cross-tab; retrieving a data source for a structured report; collecting a context for the cross-tab intersection in the data source, wherein the context includes a data value; building an analysis specification based on the collected context by extracting a slicer from the structured report and adding the slicer to the analysis specification based upon the structured report having said slicer, extracting a member of one or more master-detail pages and adding the one or more master-detail pages to the analysis specification based upon the structured report having one or more master-detail pages, extracting a default measure from the structured report and adding the default measure to the analysis specification based upon the structured report having a default measure, and adding at least one child of the member to the analysis specification based upon the member being an innermost nested member; and analyzing, with an analysis tool, the cross-tab intersection using the analysis specification. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22)
-
Specification