Browse Prior Art Database

Method for Presenting Business Intelligence Content using Colored Directed Graph

IP.com Disclosure Number: IPCOM000237272D
Publication Date: 2014-Jun-11
Document File: 8 page(s) / 231K

Publishing Venue

The IP.com Prior Art Database

Abstract

Reports are the main contents with business intelligence (BI) systems. Currently, all BI systems manage the reports using folders and organize them in a hierarchical model. This is the same as how operating systems organize files and folders.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 8

Method for Presenting Business Intelligence Content using Colored Directed Graph

The present disclosure proposes a method to visually organize and represent all BI reports using a colored directed graph. Each node of the graph represents one BI report. The node are colored according to different clusters that the report belongs to. The clusters of the reports are automatically decided based on the underlying query structure. There is an edge between two nodes if there is a drill-through defined from one report to the other. As a result, users can easily understand the whole BI content before they start to open and run any reports.

All nodes of the graph are colored to reflect the clusters of the reports. Nodes with the same color belong to the same cluster. Each report in the BI system is corresponding to

one node of the graph. The classification of nodes is computed based on the underlying queries of the corresponding reports. For any two nodes, if their underlying queries of the two reports share the same star schema or the same category of star schemas from the BI model, we consider the two nodes belong to the same class. Asa result, they are rendered by the same color.

The edges of the graph are decided by the drill-through definitions amongst the BI reports. A drill-through 'To' report is a report that a user opens by clicking a link within another 'From' report. For each drill-through definitions, we assign a directed edge from the 'From' report or node to the 'To' report or node.

The process to build a colorized directed graph of reports in a BI system is described in FIG. 1. The input 101 of the process is the BI reports or content 101A and the BI business metadata model 101B, based on which the reports are built. The BI model is hierarchically structured as a tree. Each star schema is a sub-tree of the model. Star schemas that belong to the same topic or category are group under the same folder or namespace, which also forms a sub-tree of the model tree. FIG. 2 shows an example BI model tree named 'GO Data Warehouse'. It contains three groups or categories of star schemas, 'HR', 'Sales and Marketing' and 'Finance'. Each category is a sub-tree of the model tree. Each category contains multiple star schemas, for example, category 'HR' contains star schema 'Employee expense', 'Employee ranking', etc. Further, each star schema is itself a sub-tree of the model tree 'GO Data Warehouse'. Every star schema contains one or more fact objects and multiple dimension objects.

With the input BI reports 101A and BI model tree 101B, the next step 102 is to build nodes for the graph...