With the initial release of the proCube™ BI platform, the Satori Group achieved a key milestone in the advancement of BI/OLAP (online analytical processing) technology. Through the use of the component tool Xchange, proCube™ bridges the gap between relational and multidimensional worlds. The proCube™ database consists of an unlimited number of multidimensional cubes, which are populated with “actuals” imported from source systems via proCube™ Xchange.

The rapid deployment of Xchange has enabled middle market enterprise to propagate data dynamically between transactional and analytical databases—for advanced, online, up-to-the-minute planning, budgeting, forecasting, analysis and reporting needs.

By employing the Microsoft Excel spreadsheet as an interface for the "power" user, as well as the proCube™ Web browser and user-developed front ends, proCube™ emerged as one of the key end-user BI platforms available in the market today.Features:

• Xchange automatically writes the SQL code necessary to propagate data between your company's internal or external data sources and the proCube™ analytical engine.

• Through the use of simple interfaces, users select what relational data to extract to create multidimensional Cubes in proCube™.

• Xchange is bi-directional and can be used to send data from the multidimensional to the relational database.

• Xchange is dynamic—changes originating in a relational system can be reported instantaneously to proCube™.

• proCube™ Xchange uses ODBC (Open Database Connectivity) to connect to relational databases in order to create/populate/update proCube™ Cubes.

• Through the use of Xchange's Drill-Through feature, users can see the individual records in the source relational database that make up a point in a multidimensional Cube.

• proCube™ supports the following databases and their associated vendor-specific ODBC drivers:

   

  • Microsoft SQL Server 6.5, 7.0 and 2000

  • IBM DB2

  • Oracle 7.x, 8.x, 9i, and 10g

  • Microsoft Access 95, 97, 2000, and XP

Benefits:

• Xchange directly addresses the need to instantaneously reach financial and operational data located in records databases and to use that data to budget, forecast, analyze, and report, online, in record time.

• Xchange means an end to batching, importing or duplicating data between separate database applications; no longer does staff waste time-and cause errors-by manually inputting or re-keying data into various applications, including spreadsheets.

• By allowing incremental data updates, Xchange eliminates the need to entirely rebuild multidimensional Cubes upon each change or update that occurs in the relational source.

• Users access a single set of advanced tools, deploying Xchange with great speed and ease to get data to end users.

• proCube™ supports an open-architecture environment, since it will integrate with ODBC-compliant relational data sources.