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.
- Language: English
- Size: 1 Mb
- License: Shareware
- Cost: 29.00 $
- Updated: 2008-03-25 11:34:35
Delicious
Technorati
Blogmarks
Digg
Reddit
Furl
Blinklist
Google
StumbleUpon
Windows Live
Yahoo
HelpAwards
| • pivot • relational • data analysis • olap • pivotchart | • cube • pivottable • analysis services • database |
Latest User Reviews:
Information Retriever 2.0.0
|
Store and retrieve information, like phone numbers, addresses, credit card information, etc. with handles. Once you input a piece of information and a handle, you can recall that information by inputting any piece of that handle or data, like part of a name. For example, inputting "pho" will retrieve any data whose handle contains "phone". Print the search results, or copy and paste them into documents or text boxes in other programs.
|
 |
Web Content Grabber 2.5.0.2
|
Content Grabber allows you to grab address and phone information from Internet Yellow Pages searching engines and buildup your own contact list database. It automatically parses an entire category into column-wise data sheet. Most of all, you can turn your database into standard 2x5, 2x10 or 3x10 mailing labels in just a few clicks.
|
 |
BioChem 1stRespondER Desktop 2.0
|
BioChem 1stRespondER (tm) is designed to help healthcare professionals deal with chemical and biological warfare attacks. 20 new agents added in version 2.0.
|
 |
FarmMate PalmOS 1.0b
|
Powerful helper for farmers with a lot of equipment to maintain. Includes both Palm OS Handheld and Windows Desktop versions to keep track of all the maintenance and repair data on your: Trucks, Tractors, Combines/Headers, Power Units, Field Equipment, Wells, Grain Bins Plus, keeps up with all your parts and maintenance items inventory: descriptions, prices, part numbers, cost and quantity on hand.
|
 |
FarmMate PocketPC 1.0b
|
Powerful helper for farmers with a lot of equipment to maintain. Keep track of all the maintenance and repair data on your: Trucks, Tractors, Combines/Headers, Power Units, Field Equipment, Wells, Grain Bins Plus, keeps up with all your parts and maintenance items inventory: descriptions, prices, part numbers, cost and quantity on hand.
|
 |
Trip Paylog PalmOS 1.0
|
Trip Paylog lets a long-distance trucker use a handheld computer and/or Windows to keep up with data related to each leg of a job from pickup to delivery. Tracks an unlimited number of jobs. Generates reports for a single job or over a date range. Includes a Windows companion version that shares the handheld''s data via the HotSync conduit. Windows version can create reports from trip data for export to word processors.
|
 |
ModelRight 3 for Oracle 3
|
Do you need to design, visualize or document your Oracle database? ModelRight 3 for Oracle can reverse engineer your existing Oracle database to gi ve you a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with Oracle to keep your design or database up to date.
|
 |
dsn2csv 1.0
|
dsn2csv continues the BitDaddys.COM tradition by offering the programmer a tool that allows for fast, flexible and simple access to the local host computer's ODBC table information. Please click on the above link to find out more! With dsn2csv you can export the local host ODBC table list to comma seperated values for output / redirect to a file or to the screen.
|
 |
odbc2csv 1.0
|
odbc2csv offers the programmer a simple, fast and effective method to collect DSN information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing the information it needs to process Data Sources for sql export. Extract odbc dsn information easily!
|
 |
tables2csv 1.0
|
tables2csv offers the programmer a simple, fast and effective method to collect table information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing the information it needs to process database tables for sql export. Extract sql table information easily!
|
 |
| Audio & Multimedia Business Communications Desktop Development | Education Games & Entertainment Graphic Apps Home & Hobby Network & Internet | Security & Privacy Servers System Utilities Web Development |