|
|
Home : Business : Databases & Tools
OlapCube
OlapCube Details:
| Publisher:
|
Adersoft |
| Version:
|
1.1 |
| License:
|
Shareware |
| Trial Limitations:
|
none |
| Price:
|
$29.00 |
| Operating Systems:
|
WinXP,Windows2000,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate |
| System Requirements:
|
windows 2000 or later |
| File Size:
|
1.10 MB |
| Total Views:
|
17 |
| Total Downloads:
|
0 |
| Rating:
|
 (5 out of 5 Stars) |
| Release Date:
|
3/21/2008 |
| Last Update:
|
3/31/2008 |
|
|
OlapCube Short Description:
OlapCube is a simple, yet powerful tool to analyze data.
|
OlapCube Long Description:
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 Keywords:
data analysis, cube, olap, pivot, pivotchart, pivottable, database, relational, analysis services
|
Other Software Products by Adersoft:
1) VbsEdit
|
|
We deliver articles like below right to your inbox for free:
Application development
by Arun Roy
Factors like expertise, specialization and competency make it a bit difficult to find the exact company that can offer best services addressing the aspects of cost effectiveness. Competitive environment, growing requirements and emerging technologies, all these prove that the resources, we are using since decades are not sufficient to cater our current challenging and revolutionary changing trend requirements. Advancement can be seen in the entire field with a new vigor of approach e...
Custom Software Development: Achieve High While Saving Your Time And Money
by Anne Catherine
This technology ridden world is approaching with a new development everyday. Today's high competition drives you to find the best software that fulfils the exact needs of your business in minimum possible time and at most appropriate budget. This demand brings an idea of custom software development in which exclusive and quality software is created bearing in mind the demands of your business instead of off-the-shelf software that may not help you in a long run. Generic software is sometimes dif...
Keep Your Email Secure While On The Go!
by Alexander Rodichev
If you are a frequent business traveler, you probably carry a notebook computer with you all the time. But what if you just take a vacation, or simply don't want to carry those extra pounds of electronics around? If you are like most casual travelers, you'll probably end up in an Internet cafe in a country of destination. You'll open a Web browser, type your Web mail address, and enter your password. By this time, you've probably got the feeling there might be something wrong with this....
Clean Windows Registry For Faster Performance
by Ashley Bigham
The registry of your computer is an integral part of the performance of the computer. All information concerning programs and settings is stored in the registry, helping the computer to run smoothly and efficiently when clean. It is usually divided into three sections, each handling their own processes: files associated with programs, deleting unwanted files to create memory space, and software that has been loaded on the computer and used by the computer's user. Each time you make a change in t...
Offsite Trends: Remote DBA
by Sam Casuncad
One of the greatest accomplishments of modern technology nowadays is the development of remote systems, including remote systems used in programming, such as in remote database administration, or DBA. Gone are the days of having to pay a visit to the actual physical location of the server and do what needs to be done. Nowadays, remote access is quite able to fix whatever needs to be fixed, all without the need to be physically present, unless there is an absolute need for it. < a hre...
|
Recommended Products:
|
Popular Downloads:
Advertise With Us
|
|
|
|