
	Where results make sense

Topic: OLAP

Related Topics

Database theory

Extract, transform, load

Data warehousing

Data warehouse

Relational model

Relational database

Star schema

Database management system

Database

Data mining

Fact table

RDBMS

Adabas

Business intelligence

OLAP cube

In the News (Sun 15 Nov 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

	OLAP from Cognos Software
		OLAP technology presents this complex data in ways that are simple to understand and manipulate, and gives enterprises the ability to react more quickly than competitors to new intelligence.
		Twenty-five years of expertise in information management makes Cognos an ideal provider of OLAP tools to enterprises in both the private and public sectors.
		Top enterprises in every industry employ Cognos solutions and OLAP applications to maintain their competitive edge and give employees fast access to critical information that can aid and improve performance.
	www.cognos.com /olap.html (337 words)

	SAS \| Business Intelligence \| OLAP
		OLAP cubes can be stored on any major hardware platform, from Microsoft Server 2003, HP/UX, AIX and Solaris, up to z/OS on mainframes.
		OLAP data storage and navigation are integrated into the SAS BI reporting environment.
		Full-featured interactive OLAP client applications allow users to take advantage of OLAP functions as needed to match their needs and skills.
	www.sas.com /technologies/bi/olap/index.html (305 words)

	OLAP Definitions
		On-Line Analytical Processing (OLAP) is a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.
		OLAP is implemented in a multi-user client/server mode and offers consistently rapid response to queries, regardless of database size and complexity.
		OLAP clients may be as simple as a spreadsheet program retrieving a slice for further work by a spreadsheet- literate user or as high-functioned as a financial modeling or sales analysis application.
	altaplana.com /olap/glossary.html (2686 words)

	OLAP - Wikipedia, the free encyclopedia
		The typical applications of OLAP are in business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas.
		Databases configured for OLAP employ a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time.
		OLAP takes a snapshot of a set of source data and restructures it into an OLAP cube.
	en.wikipedia.org /wiki/OLAP (1081 words)

	Open source olap - Wikipedia, the free encyclopedia
		OLAP can be an expensive area for companies with software often licensed on a per seat basis and frequently costing large sums of money.
		Mondrian - Is a Relational OLAP server written in Java which supports a wide range of the MDX query Language.
		This means that there isn't a long delay in processing cubes and you don't encounter problems such as "database explosion" which can occur with OLAP servers which store calculated values (indeed this doesn't really help if you are writing values back to the cubes).
	en.wikipedia.org /wiki/Open_source_olap (739 words)

	OLAP - a Whatis.com definition
		OLAP (online analytical processing) is computer processing that enables a user to easily and selectively extract and view data from different points-of-view.
		OLAP can be used for data mining or the discovery of previously undiscerned relationships between data items.
		An OLAP database does not need to be as large as a data warehouse, since not all transactional data is needed for trend analysis.
	searchcio.techtarget.com /gDefinition/0,,sid19_gci214137,00.html (206 words)

	Borland Conference 2000 : 6210 Implementing OLAP in Delphi Applications
		The concept of OLAP was described in 1993 by Dr. E.F.Codd, the well-known database researcher and inventor of the relational database model.
		OLAP is a popular technology for multidimensional business analysis and a key component in the data warehousing based on the multidimensional data model.
		The client-side OLAP can be applicable only if the number of dimensions is not very high, and the predictable amount of summarized data is not large, as they bring all summaries from the database server to the client application.
	www.olap.ru /desc/microsoft/odelphi.asp (10278 words)

	IBM eServer - The platform for OLAP
		OLAP databases are not intended to replace relational database technology as a repository for transactional data.
		OLAP servers such as Essbase allow customers to implement large and complex data models.
		Since OLAP databases are hierarchical, recalculation of the database is usually only problematic when the whole database needs recalculation.
	www-03.ibm.com /servers/eserver/pseries/software/whitepapers/olap.html (2351 words)

	MicroStrategy - OLAP Analysis
		OLAP delivers the simplest form of analysis, allowing anyone to slice and dice interrelated subsets of data or "cubes" with the click of a mouse.
		OLAP Analysis offers users primary access to their data warehouses in lieu of more advanced analysis functionality required by power users and analysts.
		MicroStrategy delivers OLAP Analysis with Intelligent Cubes™ -- a new analysis environment that lets business users easily and safely explore beyond the boundaries of pre-defined cubes to reach the full depth and breadth of their data warehouses -- without relying on IT to create and maintain the cube data.
	www.microstrategy.com /Solutions/5Styles/olap_analysis.asp (515 words)

	The truth is out there: you can?t ignore Olap for long - vnunet.com (Site not responding. Last check: )
		Olap tools are now considered to be the obvious means of providing the analytical functions that are needed to unlock all the information stored in the warehouse.
		Olap is being used in an increasingly wide range of applications, especially for finance and sales analysis, or for any management system that requires a flexible, top-down view of an organisation.
		Olap applications are characterised by a flexibility which enables users to view and report data any way they require, perform ad hoc analyses, carry out large-scale, complex calculations and perform dynamic exception reporting from large databases.
	www.vnu.co.uk /computing/analysis/2073756/truth-ignore-olap-long (1811 words)

	OLAP
		OLAP, On-Line Analytical Processing, is a category of software tools that provide query analysis of data stored in a database.
		OLAP tools are often used to perform trend analysis on sales and financial information.
		OLAP servers and relational databases can work in harmony to create a server environment that can deliver data to users quickly and allow them to perform the analysis needed to make the best business decisions.
	www.msu.edu /~pfisterd/Olap.html (1529 words)

	What is OLAP? - a definition from Whatis.com - see also: online analytical processing
		OLAP can be used for data mining or the discovery of previously undiscerned relationships between data items.
		An OLAP database does not need to be as large as a data warehouse, since not all transactional data is needed for trend analysis.
		OLAP products are typically designed for multiple-user environments, with the cost of the software based on the number of users.
	searchdatamanagement.techtarget.com /sDefinition/0,,sid91_gci214137,00.html (373 words)

	DBMS - April 1998 - Open OLAP
		The first effort to develop a standard OLAP API was undertaken by the OLAP Council (www.olapcouncil.org), an industry consortium with a fluctuating roster that currently has 12 members.
		At least as important as integration between OLAP client and OLAP database server is the integration of the operational data store, data warehouse, and data mart layers of the architecture.
		According to Nigel Pendse and Richard Creeth, the authors of the OLAP Report (www.olapreport.com), the market for OLAP software continues to grow at a clip of 40 percent per year, which has postponed what is seen as an inevitable shake-out in the OLAP server marketplace.
	www.dbmsmag.com /9804d14.html (3204 words)

	OLAP ModelKit™ - Interactive Reporting and Data Analysis using Pivot Table component for .NET Framework
		OLAP ModelKit™ allows developers to embed an effective OLAP technology in all Windows applications based on relational data, allowing end users to interact with huge databases, summarizing, and exploring data infinitely.
		With OLAP ModelKit™ embedded in your application, your users will be able to view any amount of data in any way considered suitable at the moment, as well as performing interactive analysis of any type and quality.
		OLAP ModelKit™ is a powerful and high-performance OLAP component specially designed to help you reduce your development time and costs while building effective decision support systems.
	www.perpetuumsoft.com /Product.aspx?lang=en&pid=32 (263 words)

	The Ultimate OLAP Dog Breeds Information Guide and Reference (Site not responding. Last check: )
		OLAP takes a snapshot of a relational database and restructures it into dimensional data.
		An OLAP structure created from the operational data is called an OLAP cube.
		However, the term was not invented until 1993 when it was coined by Ted Codd, who has been described as "the father of the relational database".
	www.dogluvers.com /dog_breeds/OLAP (781 words)

	[No title]
		OLAP is specifically designed for analyzing multidimensional data sets, where patterns and relationships between the data are not immediately obvious.
		OLAP technology is replete with specialized terms that can be a barrier to understanding its real benefits.
		This cube must be assigned to a role that corresponds to the credentials in the OLAP data source connection string.
	msdn.microsoft.com /msdnmag/issues/03/10/OLAP/default.aspx (5008 words)

	OLAP for ArcGIS Overview
		The OLAP for ArcGIS add-on allows users of OLAP server technology to view their business data in the ArcGIS environment via read-only tables.
		OLAP servers, including SAP BW, SAS OLAP Server, and Microsoft SQL Server Analysis Services, are high-capacity, multiuser data manipulation engines that support and operate on multidimensional data structures.
		OLAP offers consistently rapid response to queries, regardless of database size and complexity, and handles multiuser client/server modes.
	www.esri.com /software/arcgis/extensions/olap/about/overview.html (143 words)

	Business Intelligence Reports Queries OLAP
		OLAP Benefits for CFOs (Daman Inc.)- The Author explains how business intelligence and, more specifically, OLAP applications, are becoming increasingly important for CFOs seeking to improve cost management and the accuracy of forecasts.
		OLAP Strategies for Large Data Warehousing Projects (dataWarehouse.com)- As executives depend more and more on intelligent reports to strategize and make decisions, essential OLAP execution strategies are needed in data warehousing projects.
		OLAP, an alternative technology over spreadsheets (BusinessIntelligence.com)- In a recent study, 81% of Finance Directors cited that their highest priority is the accuracy of revenue and earnings forecasts while 63% complained of inadequate budgeting and forecasting systems.
	businessintelligence.ittoolbox.com /topics/t.asp?t=309&p=309&h1=309 (2097 words)

	Oracle FAQ: Oracle Express
		The term OLAP (On-Line Analytical Processing) was first used by E.F. Codd in 1993.
		An OLAP system is often contrasted with an OLTP (On-Line Transaction Processing) system that focuses on processing orders, invoices or general ledger transactions.
		OLAP applications were previously called Decision Support Systems.
	www.orafaq.com /faqxprss.htm (1073 words)

	Introduction to the OLAP API, 5 of 6
		Because the OLAP API makes it possible to define queries in a step-by-step process, it is also important to decide on the query modification capabilities that the application will offer the user.
		See "Tasks That an OLAP API Application Performs" for a description of the tasks that an application typically performs.
		Include the OLAP API Java classes along with the ones that you have developed.
	www.stanford.edu /dept/itss/docs/oracle/9i/olap.920/a95297/intro5.htm (1083 words)

	The OLAP Report: What is OLAP?
		The OLAP Survey has found that slow query response is consistently the most often-cited technical problem with OLAP products, so too many deployments are clearly still failing to pass this test.
		The source data for our OLAP system comes almost exclusively from relational sources, and it is reassuring to know that the man who invented the relational model, also recognized that it could not provide, without help, the rich analytics that business needs.
		Dr Codd recognized that OLAP applications were not all read-only and said that, to be regarded as strategic, OLAP tools must provide concurrent access (retrieval and update), integrity and security.
	www.olapreport.com /fasmi.htm (3897 words)

Try your search on: Qwika (all wikis)