|
|
| 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. |
|
| Updated |
Apr 1, 2008 13:29:08 | | Size | 1128 kb | | Licence | Shareware | | Status | New Release | | Languages | English | | Tags | data analysis, cube, olap, pivot, pivotchart, pivottable, database, relational, analysis services | | OS | Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista | | Homepage | olapcube.com | | Email | contact@adersoft.com | | Author | Adersoft Computing |
|
|
 click for full size
|
| Other author's software: | - VbsEdit 3.4 — VBScript editor that dramatically reduces the time you spend writing .VBS scripts. Features include Syntax coloring, Case correction, Auto-completion, Built-in debugger, Code snippets, Tons of Samples scripts, Object browser, WMI code generator
- HtaEdit 1.0.24 — HTA 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
| | Show all author's software |
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. | Short tags:
data analysis, cube, olap, pivot, pivotchart, pivottable, database, relational, analysis services | System Requirements:
windows 2000 or later | |
| | Freeware alternatives OlapCube 1.1 |
|  Free Download OlapCube 1.1 from olapcube.com |
| Similar software shotlights: | - OlapXAcc cube creator assistant 1.1 — With OlapXACC you can create multidimensional offline cubes that can be analyzed afterwards with OlapX Application or any PivotTable enables application like Microsoft Excel. It's wizard like…
- RadarCube ASP.NET OLAP control for MS AS 1.40 — RadarCube is a powerful ASP.NET OLAP control providing you with a unique chance of supplying the web site with the MS Analysis 2000 or 2005 client abilities. It is entirely authored in C# 2.0 and can…
| | Find all software similar on OlapCube 1.1 |
| Similar smart reviews: | - Advanced Data Generator - quick and easy generation of test data for your database — Whenever you develop a database-driven application of any type, database modeling and creation are an integral part of the process. However, testing cannot be properly carried out without realistic database data — you don’t see how objects, text and other database elements are rendered on the page, you can’t see a full picture of your e-commerce store full of products and…
- OraLoader - simple, fast and flexible data conversion tool for Oracle databases — As a database developer dealing with Oracle databases, you may face the problem of converting your database data to more conventional formats or, on the opposite, filling your database with data provided in standard spreadsheets or even plain text files. These operations may take a lot of time that could otherwise be spent on developing and refining more important aspects of your…
- Database Tour Pro 5.1.0.715. Manage your database with variety of functions! — For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but…
- Pivot Stickfigure Animator — There is no doubt that virtually any child in the world, regardless of cultural environment and other factors, started his or her «artistic career» by drawing stick figures. The reason is obvious — this is the simplest way of creating schematic human characters that was first used thousands of years ago by ancient cave painters. Flexible, clear and easy to draw…
- Launch Pivot, The Power On Your Desktop — Wouldn’t it be just great to do all (or almost all) of our computer tasks with just a single keystroke or click of the mouse and not have to wonder through a million of clicks on the Start menu? Check this out: From this moment on, to look at a collection of your new photos, run an office application or your favorite computer game…
- Oxy Cube, When a Mobile Meets a PC — By itself, a cell phone is just a device for, basically, making calls. A computer also has nothing special in it when it’s by itself. But what happens when you put these two together? Briefly, they make a feature-packed mobile digital assistant, with no need to buy an expensive PDA or anything else tricky and expensive — just grab a copy of the Oxy Cube…
- Cube Puzzle, Rubik' Big Brother — If you’ve caught the time of Rubik Cube’s popularity, you are very likely to have seen folks playing with it like if that was the only thing they could grab in the endless universe. But the time flew by, and the toy that used to keep folks captive magnificently was no longer interesting: all puzzles were solved, and the mind was seeking for something new. Well, what new…
- PDF Analyzer - an all-seeing PDF analysis tool that is a breeze to use — Users who work with large collections of PDF files on a regular basis — publishers, editors, technical writers, webmasters — often need to obtain detailed information about the files they deal with. Apparently, large PDF editing applications can be used for this purpose, but it’s not comfortable at all. If you would like to be able to quickly extract the necessary…
- Raise Data Recovery for NTFS, Resurrect Ceased Data — You’ve just emptied your desktop recycle bin and maybe even formatted the hard drive. A moment later, all of the sudden, you realized that some crucial documents are missing, and most likely they had ended up in that recycle bin and were erased. Is that your doomsday and time for the resignation? Or can anything be done to recover that lost and erased data? Don’t rush to resign…
| | Find all smart reviews similar on OlapCube 1.1 |
|
