Apparatus and method for facilitating trusted business intelligence through data context

• US 8,046,673 B2
• Filed: 11/07/2005
• Issued: 10/25/2011
• Est. Priority Date: 11/07/2005
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Saurel, Pierre, Polo-Malouvier, Ricardo, Ducaule, Sébastien, Cras, Jean-Yves, Piercey, Charles Arthur
• Primary Examiner(s): HUYNH, CONG LAC T
• Application Number:
  US11/269,145
• Publication Number:
  US 20070255574A1
• Time in Patent Office: 2,178 Days
• Field of Search: 715/200, 715/255
• US Class Current: 715/200
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A computer readable medium with executable instructions to analyze a report value, includes executable instructions to select a report value and identify the formula evaluated to produce the report value. Formal parameters associated with the formula are determined. The actual parameters used to compute the report value are located. The formula, the formal parameters and the actual parameters are then displayed.

Claims

1. A computer readable medium with executable instructions to analyze a report value, comprising executable instructions to:

select a report value;

identify at least one formula evaluated to produce the report value;

determine parameters associated with the at least one formula using a computation context of a plurality of computation contexts that are a part of a computation plan, each computation context comprising a set of corresponding formulas, a corresponding index with an ordered list of dimensions with sort information for each dimension, and a corresponding filtering expression, at least one of the computation contexts being synchronized to another computation context;

locate, using the computation plan, actual parameters used to compute the report value; and

display the actual parameters.

2. The computer readable medium of claim 1 wherein the executable instructions to determine parameters include executable instructions to process metadata characterizing the computation context.

3. The computer readable medium of claim 1 wherein the executable instructions to display include executable instructions to highlight values that match the actual parameters.

4. The computer readable medium of claim 1 wherein the analyzing of the report value allows a user to determine whether the report value is erroneous.

5. A computer readable medium with executable instructions to analyze a report value, comprising executable instructions to:

select a report value;

determine dimensions used to establish the report value by identifying each dimension that appears in at least one final computation node of a computation plan, the computation plan comprising of a plurality of synchronized computation contexts, each computation context comprising a set of corresponding formulas, a corresponding index with an ordered list of dimensions with sort information for each dimension, and a corresponding filtering expression; and

display the dimensions.

6. The computer readable medium of claim 5 further comprising executable instructions to identify original data source data used to compute the report value.

7. The computer readable medium of claim 5 wherein the executable instructions to determine dimensions include executable instructions to process metadata with dimension information.

8. The computer readable medium of claim 5 further comprising executable instructions to locate a filter used to compute the report value.

9. A computer readable medium with executable instructions to analyze a report value, comprising executable instructions to:

select a report value;

identify a formula evaluated to produce the report value;

determine an intermediate value for a sub-expression of the formula through a recursive call that determines parameters for the sub-expression;

determine an intermediate value for a sub-expression of the formula through a recursive call that determines parameters for the sub-expression, where the formula for computing of the report value is a complex formula involving different synchronized computation contexts of a computation plan, each computation context comprises a set of a corresponding formula, a corresponding index with an ordered list of dimensions with sort information for each dimension, and a corresponding filtering expression;

highlighting the intermediate value and measured values that are part of a corresponding computation in a report to users;

presenting to users an entire set of data acquired from data sources used to compute the report value; and

identifying inconsistent results based on the set of data presented to users.

10. The computer readable medium of claim 9 further comprising executable instructions to display the intermediate value with an operator from the formula.

11. The computer readable medium of claim 9 wherein the executable instructions to select a report value include executable instructions to select an error value.

12. The computer readable medium of claim 9 further comprising executable instructions to locate a filter used to compute the report value.