|
|
|
Categories :
Business > Databases & Tools
|
|
OlapCube 1.1
|
| Publisher |
Adersoft |
| Published Date |
2008-03-21 |
| License |
Shareware |
Price |
29 USD |
| Size |
1128 KB. |
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.
|
| |
Description From Publisher
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.
Supported OS
WinXP,Windows2000,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Win
Related Keywords
data analysis data analysis cube cube olap olap pivot pivot pivotchart pivotchart pivottable pivottable database database relational relational analysis services analysis services
|
|
Latest Databases & Tools Realted Tools:
FoxPro Paradox Import, Export & Convert Software 7.0
Transfer tables to and from FoxPro and Paradox databases. Importing and exporting can be done without SQL knowledge. This program is designed for Paradox 5 databases. Higher versions of Paradox databases can be saved as 5 and used with this program. |
DataMatch 2008 2.4
DataMatch 2008 is a powerful and comprehensive data cleansing, matching, and deduplication tool. Designed to be used by anyone, not just IT professionals, it has an intuitive interface that shows the modifications you are making in real time. |
FoxPro Change Case to Proper, Upper, Lower & Sente 7.0
Change case in FoxPro tables. Change to upper, lower, title (proper) or sentence case. Case of each word in each field (column) is changed. Connect to FoxPro via DBC file or multiple DBF files in a folder. |
Oracle Copy Tables to Another Oracle Database Soft 7.0
Copy tables from one Oracle database to another. Provide the login information for both databases. |
Oracle Join Two Tables Software 7.0
Horizontally merge two Oracle tables into one by a common column (field) of data. The two tables are not changed, a new table is created with the results. MS Access 2000 or higher required. |
GeneralKB 2.7
Create knowledge base substantiated on any category of documents. An optimal tool for categorizing, processing and finding articles, documents and web pages which allows user to keep documents systemized, to add notes and attachments. |
ModelRight 3 for Oracle 3
Whether you are a beginner or an expert database modeler, ModelRight 3 for Oracle is your answer when you need a database modeling tool that surpasses the "least common denominator" approach taken by others. |
OraDirect .NET 4.75
An enhanced data provider for Oracle-based database applications development that offers both high performance native connectivity to the Oracle database and a number of innovative development tools and technologies. |
Data Export - Text2DB2 1.0
Hxtt Data Export - Text2DB2 is a program to import TXT(CSV, TSV, PSV) into DB2(8 or upper) database. It can export data in DB2 Procedure, or embed in your application,or accord a config file. |
MyDeveloper Tools for VS.NET 2.10
A powerful MySQL development add-in for Visual Studio .NET. It integrates into Visual Studio, making all database development and administration tasks available from your favorite IDE. |
DMT SQL Decryptor 3.3
Decrypt, edit and view encrypted database objects for Microsoft SQL Server. |
Movie Library Organizer Pro 2.0
Movie Library Software for Windows. Movie library database maintenance system for private, public, corporate libraries. Our library software helps you to catalog dvds, video tapes, cds, organize member information, keep track of the circulations. |
Keyword Drag-and-Drop 1.0
No More Cutting & Pasting Data In Spreadsheets. Easy-to-Use Program! Highlight Your Rows Then Drag Over to a New Table With a Single Click. Eliminate Tedious and Repetitious Mouse Actions and Save Time. |
|
|
