OlapCube  Downloads: | Views:  | Rating:

OlapCube is a simple, yet powerful tool to analyze data. OlapCube will let you create local cubes (files with .cub extension) from data stored in any relational database (including MySQL, PostgreSQL, Microsoft Access, SQL aServer, SQL Server Express, Oracle, Oracle Express). You can explore the resulting cube with our OlapCube Reader. Or you can use Microsoft Excel to create rich and customized reports. The OLAP cube consists of numeric facts called measures which are categorized by dimensions. An OLAP cube is a data structure that allows fast analysis of data. The arrangement of data into cubes overcomes a limitation of relational databases. Relational databases are not well suited for near instantaneous analysis and display of large amounts of data. Instead, they are better suited for creating records from a series of transactions. Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarized. OLAP cubes can be thought of as extensions to the two-dimensional array of a spreadsheet. For example a company might wish to analyze some financial data by product, by time-period, by city, by type of revenue and cost, and by comparing actual data with a budget. These additional methods of analyzing the data are known as dimensions. A financial analyst might want to view or "pivot" the data in various ways, such as displaying all the cities down the page and all the products across a page. This could be for a specified period, version and type of expenditure Each of the elements of a dimension could be summarized using a hierarchy. The hierarchy is a series of parent-child relationships, typically where a parent member represents the consolidation of the members which are its children. Parent members can be further aggregated as the children of another parent. For example May 2005 could be summarized into Second Quarter 2005 which in turn would be summarized in the Year 2005.

Free download from Shareware Connection - OlapCube is a simple, yet powerful tool to analyze data. OlapCube will let you create local cube files (with .cub extension) from data stored in any relational database. You can explore the resulting cube with our OlapCube Reader or Microsoft Excel.

Publisher: Adersoft | License: Shareware | Price: 29 Version: 1 | Size: 1128 KB | Platform: WinXP,Windows2000,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Home Premium x64 Released Date: 21-03-2008 | Rating: 0 | Title: OlapCube Author Url: http://www.olapcube.com Program Info Url: http://www.olapcube.com Download Url: http://adersoft.fileburst.com/olapcube.exe Screenshot Url: http://www.olapcube.com/olapcube.gif Homepage | Download

OlapCube Related:

data analysis, cube, olap, pivot, database, relational

This category most popular software Other related categories Database Convert Easydump for Oracle Toad for SQL Server Advanced Access Repair ODBC View Import Wizard [power] DataManager .rpt Inspector Professional Suite (for CR 8.5) Free SQL Compare A Better Switchboard for MS Access Navicat 2004 (MySQL GUI - a database designer for mysql) EMS PostgreSQL Manager Full Convert Enterprise 4TOPS Excel Import for MS Access 2002 Select to Excel Application Database Management Finance Graphics Inventory Systems Legal Personal Information Management Presentation Tools

Shareware Connection periodically updates pricing and software information of 'OlapCube' from company source 'Adersoft' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'OlapCube' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of OlapCube.