OLAP Exchange® directly addresses the need to reach up-to-the-instant transactional data located in records databases, and to use that data to budget and forecast, analyze and report, online, in real time. PowerOLAP® represents the ultimate empowerment of end-users, giving them fast, and accurate, current information from all organizational sources direct to their desktops.
OLAP Exchange® 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, OLAP Exchange® eliminates the need to entirely rebuild multidimensional Cubes upon each change or update that occurs in the relational source.
Through the use of OLAP Exchange's Drill-Through feature, users can see the individual records in the source relational database that make up a point in a multidimensional Cube. The "Extended Drill-Through" feature allows you to select other fields than those present in the multidimensional Cube—i.e., relational fields that you wish to view. This feature is a formidable enhancement that will greatly facilitate reporting, especially in cases where data has to be seen from several angles that include other related and logical data fields.
MIS groups use a single set of advanced tools, deploying OLAP Exchange® with great speed and ease, to get data to end users, rather than utilizing various unsatisfactory methods to update disparate systems or to create and re-create business models.
PowerOLAP® supports an open-architecture environment, since it will integrate with ODBC-compliant relational data sources.