Abstract: A system and method for indexing non-uniquely indexed entries in a report generated with a business intelligence system, such as, for example, an on-line analytical processing (OLAP) system. A dummy index is added to each index element returned in the report. Non-unique index elements receive different dummy indices to distinguish otherwise identical row elements. The dummy index is added to a base template and optionally also to a view template of a report generator of the OLAP system.

Abstract: A selection engine for a cooperative processing network, in which databases compute portions of searches and analyses which they may most efficiently compute. A data mining network may contain large scale databases, analytic engines which communicate with the databases, and other resources, each capable of performing or executing certain functions, such as statistical functions. When a user desires to run a specified report against the databases, those functions that can be computed locally in the database are trapped and computed therein, whereas other functions, such as advanced statistical functions, may be distributed to remote analytic engines or other resources in the network. A management module may coordinate the transmission and assembly of the data, including to order dependencies. The management module may contain a selection engine to allocate computations to databases or other resources as a default, to test for load balancing before choosing a compute site, or apply other criteria.

Abstract: A remote client interface to manipulate OLAP and other reports is described. A Web client or other thin client may access an intelligence server via an intermediate network server. The network server may translate between HTML or other code supplied by the client, in order to access a database serviced by the intelligence server in all its functionality. For instance, a user may clink onto a linkable URL to access a stored report run against the remote database, and perform operations on that report, such as doing a table pivot, page down, running totals or averages, or other functions. Multiple users may access the report and other data resources using different interfaces.

Abstract: A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

Abstract: A system and method for creating a custom grouping of data in a database. A custom group object is created, a plurality of custom group elements are defined, each of the custom group elements being a subset of the custom group object and being defined by a different filter, each one of the different filters representing a logical expression of qualifications based on the data or a derived calculation of the data. Each of the different filters is resolved against the data or a subset of the data, and the plurality of custom group elements are grouped into a consolidated result set which in not naturally existing in the data structure.

Abstract: A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.