OlapCube Writer

Advertisements

Download Now
OlapCube Writer 4.3.3.0
Download NowSoftepic safe download

Quick Specs

OlapCube Writer description

OlapCube Writer is a simple, yet powerful tool to analyze data. OlapCube Writer 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. But you can also choose to use Microsoft Excel in order to create comprehensive 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.

User Reviews

Average Rating:

80%
User Rating:

0 votes
My Rating: (0 user)

Write review

Related Tags

    create cub          relational database          OLAP cube          cube          OLAP          analyze      

Related Database Utils downloads


Advertisements

Latest Added

  • no screenshot AccessToSqlite 1.0 Release 1 Build 4

    AccessToSqlite is a data conversion tool that helps database user to convert Access data to SQLite database.

    windows - Trialware
  • no screenshot MysqlToSqlite 1.0 Release 1 Build 4

    MysqlToSqlite is a data conversion tool that helps users to convert their MySQL data to SQLite databases.

    windows - Trialware
  • no screenshot FlySpeed DB Migrate to SQL Server 3.0 Build 3228

    FlySpeed DB Migrate to SQL Server is a timesaver for database migration to MS SQL and data transfer tasks.

    windows - Trialware
  • no screenshot My Visual DataBase 1.2

    My Visual DataBase is a reliable and useful development environment that enables you to create databases and compile them into independent application...

    windows - Shareware
  • no screenshot Intelligent PostgreSQL to MySQL 1.5

    PostgreSQL to MySQL is a useful application for the database administrators who need to transfer databases from their PostgreSQL server to a MySQL ser...

    windows - Demo

Advertisements
© 2009 - 2013 Softepic . All rights reserved.