OlapCube 4.3.6

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.

Product Details

Publishers Description

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.

Requirements: windows 2000 or later
Languages: English
Release Info: New Release on Dec 17, 2013
Release Notes: new charts
Related Tags: data analysis cube olap pivot pivotchart pivottable database relational analysis services

Reviews

Review OlapCube 4.3.6


Reviews of OlapCube 4.3.6

You can be the first to write a review of OlapCube!

Other products submitted by this publisher

VbsEdit 6.3.2

VBScript editor that dramatically reduces the time you spend writing .VBS scripts. Features include Syntax coloring, Case correction, Auto-completion, Built-in debugger, Code snippets, Tons of Samples scripts, Object browser, WMI code generator

Product Specifications

Download Purchase
Like this?
0% 0 votes
User Rating:

item has less then 1 vote
FileCart Rating
Publisher Adersoft
Company Address 11 rue de Turbigo

Paris, Ile de France
75001, France
Company Website http://www.olapcube.com
Company Author Adersoft Computing
contact@adersoft.com
Company Contact: Adersoft Computing
submit@adersoft.com
Company Emails Sales: contact@adersoft.com
Support: contact@adersoft.com
General: contact@adersoft.com
Company Phone Numbers Sales: 33140261741
Support: 33140261741
General: 33140261741
Fax: 33140261741
Submitted by:
Homepage Visit Homepage
License Shareware
Price $99.00
Downloads 147
OS Support Windows Install and Uninstall
File Name olapcube.exe
File Size 26.68 MB ( 27,324 KB )
Published Mar 31, 2008 (7 years ago)
Updated Dec 21, 2013 (1 year ago)

Featured Listings

Featured Products
Macro Scheduler Automation Tool
Save time and automate your PC. Record macros and build scripts with the powerful,...
SEO PowerSuite Tools
What's in SEO PowerSuite? The SEO toolset contains 4 leading-edge apps for all-round...
My Checkbook
My Checkbook makes managing your personal finances a snap. With simple daily entry...