OlapCube 4.3.5

OlapCube 4.3.5
Publisher: Adersoft Date added: 14 December, 2013
License: Shareware Size: 26.7 MB
Price: $99.00

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:

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.

Tags: Data Analysis, Cube, Olap, Pivot, Pivotchart, Pivottable, Database, Relational, Analysis Services
Platforms: 2000 , 2003 , Windows Vista , Windows2000 , Windows2003 , XP , WinXP
Requirements: windows 2000 or later
Latest Downloads

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 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

VbsEdit, the award-winning VBScript editor that dramatically reduces the time you spend writing . VbsEdit, the award-winning VBScript editor that dramatically reduces the time you spend writing .VBS scripts.

Easily learn and revise the transcription and pronunciation of Japanese kanas. We all know that Japanese is not exactly easy to learn, but with applications like this one make it a little better.

Free finance strategy analysis and study tool for options market values. Options Oracle is a free finance strategy analysis and study tool for options market values. It is a powerful software solution that lets you test different strategies and options using options market value information in real time.

OlapCube 4.3.5 - Post Your Review
 * 
 * 
     
 * 
Related Downloads

The premier image & media management tool. ThumbsPlus is a highly customizable image database / thumbnails / graphics editor application that makes it easy to catalog, locate, maintain and modify all your digital images, graphics, font, metafile, and multimedia files.

Centralized network backup solution. Handy Backup Server Network lets you control backup and recovery on all workstations and servers in your network from a central console. Backup for files, emails, HDD, SQL databases, Exchange data and other crucial information from an entire network.

Thesaurus, Synonym, Database for English, French, German, Portuguese, Spanish, Italian, Dutch, Swedish in SQL, Excel or Access - format for commercial or private use. Thesaurus, Synonym, Database for English, French, German, Portuguese, Spanish, Italian, Dutch, Swedish in SQL, Excel or Access - format for commercial or private use.

Dictionary Wordlist English Czech Bilingual Dictionary Wordlist for Czech, Japanese, Finnish, Turkish, French, Spanish, German, Portuguese, English, Italian, Dutch, Swedish, Russian, Norwegian, Chinese, Polish in SQL, MS-Excel or MS-Access - format for commercial or private use.

Technical Dictionary Dutch to English Technical Dictionary Dutch to English in Excel or ACCESS- format for commercial or private use. Vocabulary from the fields of electrical engineering, engeneering, automotive, automation, electronics, mechanical , engineering, instrumentation...

MeshMagic 3D Modeling Software Free With MeshMagic 3D, viewing and editing stl files has never been easier. Import STL files created with CAD and drafting software. You can then use MeshMagic to rotate and rescale the existing meshes.

Multi-platform IDE for DB Developers Aqua Data Studio is a modern SQL IDE that enables database developers, DBAs, and data/business analysts to develop, access, manage, and visually analyze data for multiple DBMS platforms.

Avoid pricey email marketing services by relaying email through your own server.  Gammadyne Mailer does it all: sending, receiving, list management, and tracking.  It's the perfect solution for automating your email campaigns. Avoid pricey email marketing services by relaying email through your own server. Gammadyne Mailer does it all: sending, receiving, list management, and tracking. It's the perfect solution for automating your email campaigns.

The easy, fast way to catalog your books, music and videos. Input a list of ISBNs, LCCNs, UPCs or barcodes. Readerware does the rest, cataloging your collections, complete with cover art. Automatically and effortlessly. Free barcode readers available The easy, fast way to catalog your books, music and videos. Input a list of ISBNs, LCCNs, UPCs or barcodes. Readerware does the rest, cataloging your collections, complete with cover art. Automatically and effortlessly. Free barcode readers available

XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods. XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.

Easily learn and revise the transcription and pronunciation of Japanese kanas. We all know that Japanese is not exactly easy to learn, but with applications like this one make it a little better.

Free finance strategy analysis and study tool for options market values. Options Oracle is a free finance strategy analysis and study tool for options market values. It is a powerful software solution that lets you test different strategies and options using options market value information in real time.