SYSTEM AND METHOD FOR ANALYZING DATA IN A REPORT

• US 20120221511A1
• Filed: 05/08/2012
• Published: 08/30/2012
• Est. Priority Date: 11/02/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gibson, Stephen David, Leikucs, Andrew Alexander, Winter, Stewart James
• Granted Patent: US 8,589,337 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/10 Office automation; Time management

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.

Claims

1. A method for analyzing a data value of interest in a multidimensional database, the method comprising the steps of:

identifying the data value of interest in a structured report;

retrieving a data source for the structured report;

collecting a context for the data value of interest in the data source;

building an analysis specification based on the collected context; and

analyzing the data value of interest using the analysis specification.