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 functionality is characterized by dynamic multi-dimensional analysis of consolidated enterprise data supporting end user analytical and navigational activities including:
calculations and modeling applied across dimensions, through hierarchies and/or across members
trend analysis over sequential time periods
slicing subsets for on-screen viewing
drill-down to deeper levels of consolidation
reach-through to underlying detail data
rotation to new dimensional comparisons in the viewing area
OLAP is implemented in a multi-user client/server mode and offers consistently rapid response to queries, regardless of database size and complexity. OLAP helps the user synthesize enterprise information through comparative, personalized viewing, as well as through analysis of historical and projected data in various "what-if" data model scenarios. This is achieved through use of an OLAP Server.
Virtual Cube Solutions vCube is a Microsoft Excel add-in that allows users to visualize and navigate through any dimensional data mart as if it were an OLAP cube.
514.771.2085 [email protected]
Prophix database OLAP-style navigation in the multidimensional PROPHIX database environment is well suited for budgeting. OLAP systems are powerful data analysis tools that handle large amounts of data very well. Users are able to "slice and dice" through the database to make ad-hoc reporting very easy
TM1 You may be frustrated with the time and labor involved in spreadsheet-based business planning and analysis. Do you spend 80% of your time pulling together plans, with only 20% left for analysis? Then it’s time to take the driver’s seat with your financial planning process with TM1
Essbase spreadsheet services Hyperion Essbase Spreadsheet Services provides a user-friendly spreadsheet environment for OLAP analysis with Hyperion Essbase. The Excel-based interface lets users complete powerful ad-hoc analysis through an already familiar environment
Hyperroll HyperRoll provides lightning-fast access to large data volumes while reducing the need for additional system resources, and works seamlessly within customers’ existing business intelligence environments without the need for application modifications.
Webfocus WebFOCUS is a comprehensive and fully integrated enterprise business intelligence platform whose architecture, integration, and simplicity permeate every level of the global organization – executive, analytical, and operational – and make any data available, accessible, and meaningful to every person or application who needs it, when and how they need it.
IR Analytics Create, validate and seamlessly deploy predictive models with IR Analytics. By leveraging mixed-data and superior algorithms, our models are 20-60% more accurate than traditional models
iQubz Small and mid-size businesses have been deprived of deploying powerful analytics and reporting primarily for two reasons: technical complexity and high cost of development. At iQubz™, we believe, that shouldn’t be the case any longer. Analysis (OLAP) tools for building and viewing multidimensional cubes are now within everyone’s reach.
Executive Viewer Executive Viewer removes the barriers that impede decision making by offering true dynamic interaction with OLAP databases.
