OlapCube v.1.1

Advertisement
Advertisement

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.

OlapCube is a powerful tool to analyze data. 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.

cube, olap, pivot, pivottable, relational, analysis services, data analysis, pivotchart, database

 
  • OlapCube
  • 1.1
  • Adersoft
  • WinXP, Windows2000, Windows2003, Windows Vista
  • Shareware
  • 1.1 Mb
  • 322
  • $29.00
 
 

Review OlapCube

  • captcha
 

Other software of Adersoft
  • Adersoft VbsEdit  v.2.0AderSoft VbsEdit 2.0 is an award-winning VBScript editor (for VBS files - Wscript - WSH) that includes the following features: Debug mode Dynamic help Syntax coloring Find / Replace Undo / Redo Line and column numbering Run VBScripts from the editor ...
  • HtaEdit  v.1.0.24HTA editor and debugger that dramatically reduces the time you spend writing HTML applications. Features include Syntax coloring, Case correction, Auto-completion, Built-in debugger, Code snippets, Object browser - http://www.htaedit.com ...
  • OlapCube Writer  v.3.0.3.0OlapCube Writer 3.0.3.0 comes as a powerful yet simple tool that is specifically designed to help you analyze your data and create great reports. OlapCube creates data cubes locally on your computer. These standard cubes are stored in files with a ...

New Database Management software
  • Reflect Free CRM Customer Database  v.3.01Reflect Free CRM Customer Database Software lets users track interactions, notes, information, tasks, and events. Contact management helps businesses build better relationships with clients and know customers better.
  • Vehicle Fleet Manager  v.4.0.6901Designed to service large fleets, small fleets, and everything in between, our fleet management solution will track vehicle and driver statistics, maintenance records, fuel stats, and more.
  • Excel Add-in for SQL Server  v.1.7Devart Excel Add-in for SQL Server allows you to use powerful Excel capabilities for processing and analysis of data from SQL Server or SQL Azure, editing external data as usual excel spreadsheets and saving data changes back to the data source ...
  • Excel Add-ins for FreshBooks  v.1.7Devart Excel Add-in for FreshBooks allows you to use powerful Excel capabilities for processing and analysis of data from FreshBooks, editing external data as usual excel spreadsheets and saving data changes back to FreshBooks ...
  • Free Anti-Smoking Screensaver  v.1.0Do you keep on trying to quit smoking but always fail and light a cigarette again? Our Free Anti-Smoking Screensaver will help you to get rid of this addiction.
  • ModelRight for SQL Server  v.3Whether you are a beginner or an expert database modeler, ModelRight 3 for SQL Server is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others.