Factbites
 Where results make sense
About us   |   Why use us?   |   Reviews   |   PR   |   Contact us  

Topic: OLAP cube


Related Topics
RFI

  
  Designing OLAP Cubes
An OLAP cube is a specially designed database that is optimized for reporting.
OLAP cubes are fundamentally different in that they "pre-aggregate" the data used to answer many of queries that are anticipated.
The OLAP cube "knows" the hierarchy, so if the analyst issues the command to "drill down", the cube knows the next level of data to be presented.
www.databaseanswers.org /designing_olap_cubes.htm   (1757 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.
The cube metadata is typically created from a star schema or snowflake schema of tables in a relational database.
en.wikipedia.org /wiki/OLAP   (1232 words)

  
 Tips for Optimizing SQL Server OLAP/Data Warehouse Performance -- Cubes
If your OLAP cubes are large or very busy, you may want to consider putting the cubes on separate dedicated servers in order to distribute the load.
Once your OLAP cubes are in production, use the Usage Analysis Wizard to analyze the queries performed on the cubes, and use the Usage-Based Optimization Wizard to tune your cubes for maximum performance.
As a cube is processed, it is not unusual for the amount of temporary disk space to exceed the size of the cube itself.
www.sql-server-performance.com /olap_performance_cubes.asp   (1940 words)

  
 Create OLAP Cube - excel, OLAP, cube
OLAP involves working with information, where you want to group data, in order to summarize numerical fields, or to count occurrences or get the highest/lowest value in a series of data.
To be able to create an OLAP cube from the information in the database, we must be able to structure the data as a single table containing the information we want.
To be able to use the cube with our Excel OLAP Tool, you have to save the file with all data in it, and save the file in the save folder as OLAP Tool.
wang.se /en/CreateOLAPCube.html   (800 words)

  
 OLAP cube - Wikipedia, the free encyclopedia
OLAP (on-line analytical processing) was a term coined by E.F. Codd and Associates who published a white paper in 1994, commissioned by Arbor Software (now Hyperion Solutions), entitled ‘Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate’.
OLAP cubes can be thought of as extensions to the two-dimensional array of a spreadsheet.
In database theory, an OLAP cube is an abstract representation of a projection of an RDBMS relation.
en.wikipedia.org /wiki/OLAP_cube   (991 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)

  
 Relational extensions for OLAP
OLAP applications usually require many different aggregates to be computed when a user is manipulating a specific OLAP cube.
Cube models tend to describe all views that different users might want for the data that are being analyzed.
cube defined here would be queried using predicates to limit the data retrieved to the subset of interest for a report or analytical exercise.
www.research.ibm.com /journal/sj/414/colossi.html   (6734 words)

  
 Session # 1 - The Structure of OLAP Data
OLAP is one of the worst acronyms I have ever seen – when you tell someone what the letters stand for, you still don’t have the slightest idea what the software actually looks like.
The key for OLAP is the ability to navigate to different views of the data.
OLAP Filtering Is Called Slicing – You can use a dimension for slicing when it isn’t being displayed on the columns or rows of the spreadsheet.
www.localcubetask.com /session1.htm   (3478 words)

  
 Data Warehousing Review - Designing OLAP Solutions
After working out the business information of interest to extract from a data warehouse, and designing the OLAP cube with the relevant dimensions and measures, the next step is to choose the type of storage for the OLAP cube.
Users were given freedom to conducting OLAP queries depending on their levels of permission.
OLAP storage is one of the critical choices to be made when designing the solution.
www.dwreview.com /OLAP/OLAP_Comparison.html   (594 words)

  
 OnLine Analytical Processing (OLAP) - Whitepaper
OLAP services includes a middle_tier server that allows users to perform sophisticated analysis on large volumes of data with exceptional performance.
OLAP services organizes data from a data warehouse into multidimensional cubes with pre calculated summary information to provide a answers to complex analytical queries.
OLAP is a key component of data warehousing, and OLAP Services provides essential functionality for a wide array of applications ranging from reporting to advanced decision support.
www.ebizis.com /techcenter/olap.html   (1600 words)

  
 SAS | Business Intelligence | OLAP
Cubes can be created based on any data stored in any database on any operating system.
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.
www.sas.com /technologies/bi/olap/index.html   (330 words)

  
 An Introduction to OLAP in SQL Server 2005
OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail.
OLAP leverages existing data from a relational schema or data warehouse (data source) by placing key performance indicators (measures) into context (dimensions).
The processed cube can then be made available to business users who can browse the data using a variety of tools, making ad hoc analysis an interactive and analytical process rather than a development effort.
www.devx.com /dbzone/Article/21410/1954?pf=true   (1917 words)

  
 OLAP Performance
In a typical cube, the number of aggregations possible is extremely large, so calculating all of them in advance isn't desirable because of the required storage space and the time it takes to create the aggregations.
When you tell OLAP Services to calculate aggregations for a 20 percent speedup, OLAP Services picks key aggregations (which are distributed across the cube) to minimize the time required to determine any other aggregations at query time.
A cube partition is a separately managed unit of storage for the cube.
www.sqlmag.com /Articles/Index.cfm?ArticleID=7638   (2309 words)

  
 The Value Added by a Second OLAP Client Tool
OLAP client tool designers are finding new ways to show the patterns, trends, and exceptions that users want to see.
The purpose of the dimensions and levels and measures of an OLAP cube is to match the organization of data in the analyst’s mind.
The OLAP client tools in Microsoft Office are an excellent choice for the user who is less familiar with OLAP, as long as certain issues are addressed.
www.localcubetask.com /valueadded.htm   (1737 words)

  
 Manipulate and Query OLAPData Using ADOMD and Multidimensional Expressions-- MSJ, August 1999
OLAP lets data from the warehouse be extracted, summarized, organized, and stored in multidimensional structures to enable rapid response to user queries.
OLAP lets data from the warehouse be extracted, summarized, organized, and stored in multidimensional structures (known as OLAP server cubes) to enable rapid response to user queries.
Cubes are defined in terms of dimensions and measures.
www.microsoft.com /msj/0899/mdx/mdx.aspx   (4015 words)

  
 SAS | OLAP Server
SAS OLAP Server is a multidimensional data store designed from the outset to provide quick access to presummarized data, generated from vast amounts of detailed data.
SAS OLAP Server is designed for CIOs who want to deploy a fast enterprisewide source for reliable summaries of strategic information, IT managers with large numbers of end users requiring rapid self-service navigation through summarized data, and department heads whose teams require frequent access to summaries to support business analysis and decisions.
SAS OLAP Cube Studio, a stand-alone cube-building tool, can be used to easily define data measures, dimensions and aggregations.
www.sas.com /technologies/dw/storage/mddb   (521 words)

  
 OlapX OLAP tools - What is OLAP
OLAP or On Line Analytical Processing is the formal name of multidimensional analysis - another way to look at information intuitively.
With OLAP you can look at a set of corporate data in many different ways without much effort.
OLAP files or cubes are model the data in dimensions.
www.olapxsoftware.com /en/WhatIsOlap.asp   (454 words)

  
 XL2000: Editing Local OLAP Cube Creates New Cube
When you edit the local offline OLAP cube (.cub) file for your PivotTable, Excel creates a new.cub file instead of updating the original.cub file.
After reconnecting locally, edit the local cube and then re-create the PivotTable for layout changes that were removed.
When you share or distribute a workbook containing a PivotTable, and the data in the PivotTable is based on a local OLAP cube (.cub), you must distribute the.cub file with the workbook.
support.microsoft.com /kb/210777   (517 words)

  
 OLAP SAS Cubes- Data Warehousing Data Mining Decision Support Solutions - Statistical Analysis
Our OLAP solutions can be easily integrated into your existing hardware and software environment.
Sever-side processing for a web request through PTS is much quicker when accessing a ready-made Microsoft Analysis Services OLAP cube than when accessing a SQL Server table.
The same is true for the Microsoft Pivot Table Services, or Microsoft Excel using remote data, e.g., a remote SAS OLAP cube, a remote SQL Server database, or a remote Microsoft Analysis Services OLAP cube.
www.palisadesresearch.com /olap.htm   (584 words)

  
 Hitachi Consulting: OLAP Solutions Bootcamp
By learning the ins and outs of dimensions, cubes, interfaces, wizards, and working with the more advanced features of Analysis Services, students will achieve a complete and correct understanding of how to use Analysis Manager to create cubes for their own databases.
Use the Cube Editor to create and manipulate cubes, add measures and dimensions, and assign properties to improve cubes.
In this module, students use various cube and dimension techniques to build cubes from the Foodmart 2000 database by using Analysis Services.
www.hitachiconsulting.com /page.cfm?ID=trainingOLAPSolutions   (927 words)

  
 olap.com
OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
OLAP enables end-users to perform ad hoc analysis of data in multiple dimensions, thereby providing the insight and understanding they need for better decision making.
With our solutions, OLAP is more: it is FAST, EASY, SIMPLE, CONTROLLABLE access to the intelligence locked in your data.
www.olap.com   (489 words)

  
 IQub OLAP Browser - Cube Viewer that Connects to MS SQL Server cubes
IQub’s OLAP Browser is a multidimensional, data analysis and reporting software application (self-service) primarily for Microsoft SQL Server clients, but also for Oracle and others.
IQub’s OLAP Browser is a data cube viewer for online analysis and reporting.
Our advantage over other cube viewers is simplicity – easy to deploy and easy to use.
www.iqub.com   (189 words)

  
 FIX: Users Cannot Access OLAP Cube from Clients After Installing SP1
If a user is a Windows NT administrator of the OLAP server computer but is not a member of the OLAP administrators group, cube access is always denied.
Contact the OLAP cube administrator and, if necessary, setup a new data source to connect to the cube.
Removing the user from the Administrators group on the server computer provides the user access to OLAP cubes for which he/she has permissions.
support.microsoft.com /default.aspx?scid=kb;en-us;236315   (323 words)

  
 Mastering OLAP: Local Cube Files
Let's examine how to use OLAP Services and Excel 2000 to create a local cube file from an OLAP cube slice to work with while you're traveling.
A local cube file is a self-contained OLAP cube without any stored aggre- gations.
Typically, you use a local cube file as a subset of a server-based OLAP cube to take on the road.
www.sqlmag.com /Articles/Index.cfm?ArticleID=7842   (1163 words)

  
 The OLAP Report: Product reviews
We do not believe that reviews of this detail, on such a wide range of OLAP products, are available anywhere else; and even the less detailed reviews that are available elsewhere are not kept up to date in this way.
A well established production reporting tool that can not only access popular OLAP databases, but provides basic OLAP analysis on live data from a myriad of both modern and legacy sources.
The two financial OLAP applications from the former Hyperion Software, now part of Hyperion Solutions and superseded by modern Web-based replacements also reviewed in The OLAP Report.
www.olapreport.com /ProductsIndex.htm   (1033 words)

  
 Chart FX Extensions Pack: More Specific Data, Less Code Written.
Just drop a chart in your form and make it OLAP aware in just minutes with the Chart FX OLAP Data Wizard*, or just use Visual Studio's Intellisense® technology to quickly customize and configure your charts by accessing Properties and Methods available to the chart object.
The Chart FX OLAP Extension also allows end users to pivot data in the chart to change the dimensional orientation.
The OLAP Extension supports analysis and drill down functionality allowing end users to analyze a level individually, or drill down to a selected level to analyze the subordinate values which comprise the selected level.
www.softwarefx.com /Extensions/OLAP   (614 words)

  
 Page 3 - Exploring OLAP Cube with Visual Basic
In order to connect to the OLAP server, you need to add references to the Microsoft ActiveX Data Objects 2.6 (recent versions include up to 2.8) library, which should add the msado2.6.tlb (the same as msado15.dll).
In order to access the OLAP objects, reference to the Microsoft ActiveX Data Objects (multi-dimensional) 2.6 library should be made, which adds the msadomd.dll to the project as shown below.
You article about Olap (cubes) with VB (6.0) was very interesting.
www.aspfree.com /c/a/Database/Exploring-OLAP-Cube-with-Visual-Basic/2   (1227 words)

  
 OlapX OLAP tools - Cube creation
OlapX Cube creator assistant (OlapXACC) is our multidimensional cube creation tool.
IT enables It departments to create their own offline multidimensional cube files to use then with OlapX Application or any PivotTable enabled application like Microsoft Excel.
The product acts like a wizard guiding its users step by step in the process of creating their cubes.
www.olapxsoftware.com /en/olapXACC/olapXACC.asp   (90 words)

  
 Cube (Mondrian OLAP Server, version 2.1.1)
for which this cube is the context for lookup up members.
Returns the time dimension for this cube, or
Helper method that returns the Year Level or returns null if the Time Dimension does not exist or if Year is not defined in the Time Dimension.
mondrian.sourceforge.net /api/mondrian/olap/Cube.html   (153 words)

  
 OLAP ( Online Analytical Processing, OLAP Cube, On-line Analytical Processing Software, Multidimensional Online ...
OLAP (Online Analytical Processing, OLAP Cube, On-line Analytical Processing Software, Multidimensional Online Analytical Processing, MOLAP, Multidimensional OLAP, and Online Analytical Processing Software) Definition
HOLAP was developed to combine the greater data capacity of ROLAP with the superior processing capability of OLAP.
SUMMARY: This paper outlines key findings from The OLAP Survey 5, the leading independent survey of the business intelligence (BI) market space.
www.bitpipe.com /tlist/OLAP.html   (577 words)

Try your search on: Qwika (all wikis)

Factbites
  About us   |   Why use us?   |   Reviews   |   Press   |   Contact us  
Copyright © 2005-2007 www.factbites.com Usage implies agreement with terms.