Content based approach to extending the form and function of a business intelligence system

• US 8,468,177 B2
• Filed: 09/28/2010
• Issued: 06/18/2013
• Est. Priority Date: 09/29/2009
• Status: Expired due to Fees

• Current Assignee: ZAP! Holdings LLC
• Original Assignee: ZAP! Holdings LLC
• Inventors: Reeves, Christopher John, Meynink, Todd William
• Primary Examiner(s): LU, KUEN S
• Application Number:
  US13/498,427
• Publication Number:
  US 20120185425A1
• Time in Patent Office: 994 Days
• Field of Search: 707/802
• US Class Current: 707/802
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A business intelligence (BI) system which includes the ability to extend its functionality outside of the project life cycle by means of specific content. Complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query. Each sub tree is valid in isolation when provided with the proper context. Any sub tree can be an expression template, stored as application content, which at generation time uses simple text substitution with instance specific parameters to produce multidimensional expression syntax. The system includes a sophisticated type system and semantic layer that hides the user from the complexities inherent in working with OLAP databases. A business intelligence expert can provide type and semantic cues for each expression template, held as content. The content expression templates are then exposed in the application primarily through a context menu that is filtered for appropriateness, but also in an explorer tree, toolbars, menus and submenus. The functionality from a users perspective is integral to the application. An iterative processing capability to complement these expressions is provided by means of OLAP database stored procedures held as application content. Building on the above, workflow content allows business users to extend the application by creating expert-system-like guided analyses and processes. Of key significance to this innovation is the concept that the expression templates, stored procedures and workflows are application content, and therefore redistributable and unshackled from the classic software development lifecycle and the cost and expertise associated.

Claims

1. A computer readable storage medium including executable instructions as part of a business intelligence query system which includes the capability to iteratively process data during execution, wherein

complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query wherein each sub tree is valid in isolation when provided with the proper context;

wherein each sub tree is stored in the application content; and

some subtrees are expression templates and the type and semantic rules, as applied to a single expression template, are held as content.

2. A computer readable storage medium including executable instructions as claimed in claim 1 in which the type and semantic checks are performed at design time and are not revalidated at generation time.

3. A computer readable storage medium including executable instructions as claimed in claim 1 wherein additional input fields are used including a default field and a parent hierarchy field.

4. A computer readable storage medium including executable instructions as claimed in claim 1 which includes a context menu available for query parts which displays the applicable expression templates and employs a type system and semantic logic to filter available expression templates.

5. A computer readable storage medium including executable instructions as claimed in claim 1, which includes a drill through-on-calculated-members solution, at the application level, that allows the template designer to specify a substitutable drill through set expression.

6. A computer readable storage medium including executable instructions as claimed in claim 1, which marks all aliased elements, within a generated query, with a globally unique identifier to the end of generalising context expression templates to be substantially cube and context agnostic.

7. A computer readable storage medium including executable instructions as claimed in claim 1, which uses the parse-tree-like structure to recursively execute components to determine context expression templates that have introduced errors or performance issues.

8. A computer readable storage medium including executable instructions as claimed in claim 1, which provides multidimensional expression extensions that are substituted at generation time to generalise context expression templates sufficiently to be cube and context agnostic.

9. A computer readable storage medium including executable instructions as claimed in claim 1, wherein reporting content and reporting functions are reusable.

10. A computer readable storage medium including executable instructions as claimed in claim 1, which uses four resource types saved as content wherein the resource types are multidimensional expression templates, OLAP database stored procedures, composite templates and data-mining algorithms and workflow.

11. A computer readable storage medium including executable instructions as part of a business intelligence query system which includes the capability to iteratively process data during execution, wherein

complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query wherein each sub tree is valid in isolation when provided with the proper context;

wherein each sub tree is stored in the application content; and

some subtrees are expression templates which at generation time use simple text substitution with instance specific parameters to produce multidimensional expression syntax.

12. A computer readable storage medium including executable instructions as claimed in claim 11, which exposes the content expression templates in a context menu, wherein the list of templates is filtered using a type system and semantic logic.

13. A computer readable storage medium including executable instructions as claimed in claim 11 wherein additional input fields are used including a default field and a parent hierarchy field.

14. A computer readable storage medium including executable instructions as claimed in claim 11, which includes a drill through-on-calculated-members solution ,at the application level, that allows the template designer to specify a substitutable drill through set expression.

15. A computer readable storage medium including executable instructions as claimed in claim 11, which marks all aliased elements, within a generated query, with a globally unique identifier to the end of generalising context expression templates to be substantially cube and context agnostic.

16. A computer readable storage medium including executable instructions as claimed in claim 11, which uses the parse-tree-like structure to recursively execute components to determine context expression templates that have introduced errors or performance issues.

17. A computer readable storage medium including executable instructions as claimed in claim 11, which provides multidimensional expression extensions that are substituted at generation time to generalise context expression templates sufficiently to be cube and context agnostic.

18. A computer readable storage medium including executable instructions as claimed in claim 11, wherein reporting content and reporting functions are reusable.

19. A computer readable storage medium including executable instructions as claimed in claim 11, which uses four resource types saved as content wherein the resource types are multidimensional expression templates, OLAP database stored procedures, composite templates and data-mining algorithms and workflow.