OlapCube Writer

Simple, yet powerful tool to analyze data

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.
Operating system:
Windows 2K / XP / 2003 / Vista / Vista 64 bit / 7 / 7 64 bit / 8 / 8 64 bit

Program specification:


    Technical details:

  • Version:
  • File size: 47 MB
  • File name: olapcube.exe
  • Last update:
  • Platform: Windows 2K / XP / 2003 / Vista / Vista 64 bit / 7 / 7 64 bit / 8 / 8 64 bit
  • License: Trial
  • Price:$99.25
  • Company: Adersoft (View more)

Related Programs:

Appin Homtech course on Ethical Hacking& Network Security

Appin Homtech course on Ethical Hacking& Network Security 3.1

Learn to hack ethically
Price: $0, Rating: 9.39, Downloads: 396 Download

csFileDownload 3.0

This ASP component enables file downloads to be controlled from within a script. It allows for password protection of individual files, and for record keeping. A built in access code generator is included. There are also some file utility functions.
Price: $35, Rating: 1, Downloads: 289 Download
TreeBase Generator

TreeBase Generator 1.0

With TreeBase Generator you will receive a MS Windows based application. It was tested on Win 98, ME and 2000. TreeBase Generator will create a new database for you and will also generate a complete w
Price: $ 79, Rating: 10, Downloads: 237 Download
ParetoLogic Privacy Controls

ParetoLogic Privacy Controls 2.0

Finds and erases confidential information.
Price: $ 29.95, Rating: 9, Downloads: 224 Download

QueryShark 3.0

QueryShark is an easy to use, agent-less tool to collect system information from your network of Windows based computers.
Price: $ 295, Rating: 10, Downloads: 173 Download


User Rating

Rating: 4.3 out of 5
Based on 4 ratings. 4 user reviews.

  • Currently 4.25 out of 5
  • 1
  • 2
  • 3
  • 4
  • 5


OlapCube Writer screenshot. Click to enlarge!