Must Have | TOP 100 | Authors | Reviews | RSS | Submit

Recommended Software

VentaFax Business

VentaFax Business 6.0

VentaFax is a full-featured fax and answering machine software with color fax support. It sends and receives faxes and turns your PC with a fax modem into a versatile answering machine with remote control and email integration. You can retrieve your fax and voice messages from any touchtone phone...

DOWNLOAD
 
 

OlapCube

OlapCube 1.1

OlapCube Screenshot

Category: Business & Productivity Tools / Database Management | Author: Adersoft

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.

DOWNLOAD GET FULL VER Cost: $29.00 USD
License: Shareware
Size: 1.1 MB
Download Counter: 9

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
OS Support: Windows 2000, Windows XP, Windows 2003, Windows Vista
Language Support: English

Released: March 21, 2008 | Added: April 18, 2008 | Viewed: 164
 

Related Software

72t analysis | Analysis Services | Cube | Data Analysis | Database | Dll analysis | Hdd analysis | Iis Log Analysis | Log Analysis | Olap | Pivot | Pivotchart | Pivottable | Relational | Statistics Analysis | System Analysis | Systems Analysis | Visual Analysis

  • OlapX Application Icon OlapX Application - 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 Services databases.
  • OLAP ModelKit Icon OLAP ModelKit - One of the first OLAP components for .NET written in C# and containing managed code. The product is remarkable for a modern XP Themed appearance, an ability to use any .NET data sources and ability to present data via any third party chart components
  • 3-way TANGRAM Icon 3-way TANGRAM - A complete desktop OLAP engine for handling hypercube data.
  • Visual SQL-Designer Icon Visual SQL-Designer - 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 databases. Union query builder.OLAP inside.Stored Proc
  • OLAP Reporting Tool for Excel Icon OLAP Reporting Tool for Excel - Extends the built-in OLAP features in Excel to make them easier work with, especially for workgroups. Users can easily share customized reports. Display a graph or a table or combinations of both. Choose between all Excel graph types, multi, 3-D.
  • StatCalc Icon StatCalc - 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.
  • No Icon The Query Tool - The Query Tool is a powerful data mining application. It allows you to perform data analysis on any SQL database. It has been developed predominately for the non technical user.
  • Logbook Pro Icon Logbook Pro - Advanced aviation logbook for Windows. Completely customizable, comprehensive reports, interactive charts, custom currencies, powerful data analysis, and free tech support. Try risk free with no time limits. Palm and Pocket PC Companions!!!
  • Optimal Trader Icon Optimal Trader - Stock Analysis Software with cutting edge technology. Optimal Trader offers technical analysis based on modern signal processing and neural networks. A large database with stocks, mutual funds, currencies and indices is available for free.
  • No Icon AfalinaSoft XL Report.NET - A .NET component to create EXCELlent reports with minimal coding. Get impressive results! ONLY 3 minutes and ONE LINE of code and multiple sheet report with a pivot table and a pivot chart on every worksheet is ready! See ExcelReport.com/net/
 

Actual Software | Link To Us | Links | Contact

Must Have | TOP 100 | Authors | Reviews | RSS | Submit