OlapCube 1.1


Program Specifications
Download OlapCube

OlapCube 1.1
  View more screenshots
  Version:1.1 
  Size:1.40 MB
  Publisher:Adersoft
  Date Added:Dec 11, 2008
  License [?]:Shareware (USD$29.00 to buy)
  Operating System:WinXP, WinVista, Win2003, Win2000
  Requirements:
  Download Links:Download OlapCube
BumperSoft Editor's Review Status:

Publisher's Description of OlapCube
 
" OlapCube is a simple, yet powerful tool to analyze data. "
- From Adersoft

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 2007 could be summarized into Second Quarter 2007 which in turn would be summarized in the Year 2007.

Share OlapCube with Friends
Recommend OlapCube 1.1

Tags
data  |  analysis  |  cube  |  olap  |  pivot  |  pivotchart  |  pivottable  |  database  |  relational  |  services  

RELATED DOWNLOADS
(Databases)

DBSync for MS Access & MySQL 6.01
Bi-directional convertion and synchronization of MS Access and MySQL databases.
Multiple Database Query Analyzer 2.1
Supports querries with different types of databases.
MySQL-to-Oracle 2.3
A program to migrate MySQL databases to Oracle server.
Database Viewer Plus (Access,Excel,Oracle) 3.2
View and Sync Ms Access, Excel, Oracle, any ODBC enabled database with Palm.
WEEK'S TOP DOWNLOADS
(All Categories)

1.Wolfenstein 3D
2.WinPcap
3.IntelliAdmin USB Drive Disabler
4.TuneUp Utilities
5.Macromedia FreeHand MX
6.Boson Router Simulator
7.Uni2Me
8.Microsoft Global IME (Input Method Editor) 5.02 for Windows 95, 98, and NT 4.0
9.Windows Media Encoder 9 Series x64 Edition
10.MiKTeX
More information
Download HelpRSS   Newsletter
Submit SoftwareContact UsAbout BumperSoft