|
|
|
OlapCube 1.1 Get
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.
Select link to download "OlapCube":
|
|
OlapCube Related Downloads
|
| OlapX Application 4.0 |
 |
| OlapX is a sophisticated multidimensional database browsing tool. It enables the creation of multidimensional cubes and the interactive analysis, reporting and presentation of Microsoft's Analysis... |
| Visual SQL-Designer 4.01 |
 |
| Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it. Support ORACLE, MSSQL 6.5-7.0-2000, MySQL,SyBase, Db2 for NT, MSAccess and other ODBC... |
| RadarBI 2.03.0 |
 |
| RadarBI is a tool for creating and viewing interactive dashboards with powerful analytical facilities. Allows creating reports viewable both in Web and Windows with the use of standard charts,... |
| Pivot4U 1.3 |
 |
| Pivot4U is an add-in for Microsoft Excel. Once installed, it allows you to edit data directly in pivot tables. All the power of calculations and planning FROM ABOVE-DOWNWARD becomes readily... |
| KonSi Data Envelopment Analysis DEA 5.1 |
 |
| KonSi Data Envelopment Analysis for Benchmarking provides performance measurement using Data Envelopment Analysis. With DEA Analysis it is easy to conduct the efficiency analysis of benchmarking... |
| Pivot Table Helper 1.0 |
 |
| It makes working with pivot tables comfortable and fast. Pivot Table Helper adds its own toolbar to Excel that allows you to select pivot table areas, to set pivot field formatting, to add/remove... |
| MindModel 2.82 |
 |
| MindModel is very easy-to-use relational database software that allows you to store and recall information on any topic. Toll-free technical support. PC, LAN and Web versions available. |
| StatCalc 5.4.3 |
 |
| Easy to use desktop analysis tool that simplifies common statistical calculations and also allows quick analysis of raw data whether you enter it yourself, use a spreadsheet, or maintain a database. |
| AutoFormat for PivotTables 1.63 |
|
| The add-in saves pivot table formatting and further uses it as a format template. It stores formatting of each pivot table area (page, row, column, and data fields) and all format options such as... |
| Valentina Office Server 4.1 |
|
| OLAP ready, high performance vertical SQL database server with visual reporting services. Build fast, client-server or server only applications - web, .net, iPhone and more. Migrate your data and... |
|
|
|
