Olap server - Oracle Essbase
On Habré, at least as a description of the solution from Microsoft for the problems of analytical data processing in real time is presented , but there is not a word about the world leader in this issue, Oracle Essbase .
Oracle EssBase is an OLAP server that differs from its competitors with powerful support for analytical tasks, allowing you to perform multidimensional analysis across a multitude of analysts, build company development forecasts, and prepare data for reporting. It supports the full range of OLAP solutions - MOLAP (two types of Aggregate Storage and Block Storage), ROLAP and HOLAP (MOLAP + ROLAP).
The architecture can be schematically represented as follows:
')
It consists of the following components:
• Essbase Analytics Module (Block Storage)
This Analytic Services module creates a database based on the notion of a block - this is a table consisting of all possible variants of dense directions, and these blocks are located at the intersection of discharged directions. This module supports the recording of values using custom applications and is intended for integrated financial analysis.
Created for
• Enterprise Analytics Module (ASO Aggregate Storage)
This Analytic Services module creates an “aggregated” database, stores elements of zero level in itself, automatically calculating all values of a higher level, in its structure resembles ROLAP in its structure. Designed for the analysis of very large data (extremely discharged), with millions of possible indicators.
Created for
• Analytic Administration Services administrative console
This is the Analytic Services database administrator interface that supports a single administration point for multiple database servers. Using this tool, you can develop, maintain and manage both servers and applications and their databases.
• Integration Console - Essbase Integration Studio (not developed, the predecessor of Essbase Integration Studio)
Integration Server is a server that uses a multi-threaded architecture, serving communication between relational data sources, an OLAP metadata catalog, and an Analytic Server (a multidimensional database server).
• Essbase SpreadSheat Add-in for Excel
This software solution is designed to receive AD-HOC reports in Microsoft Excel, it is directly connected to the multidimensional database. Development is stopped.
• Smart View for Office
Allows you to access data from the entire package of Microsoft Office, differs from Essbase SpreadSheet technological solution. Intensively developing.
• EssCMD
The command line interface is designed for administrative tasks, such as stopping an application, starting service utilities, backing up, etc.
• MaxL DDL
Command line interface for administrative tasks.
• Essbase API
This software developer tool allows you to access a multidimensional database from VB, C, or JAVA.
• Maintenance Services - Analytic Deployment Services
Allows you to build a single entry point for load balancing and fault tolerance between user applications and multidimensional databases.
Well, in the end there are several resources that will help in mastering this technology.
Oracle by Example
Configure Essbase for those who are in the tank
Oracle EssBase is an OLAP server that differs from its competitors with powerful support for analytical tasks, allowing you to perform multidimensional analysis across a multitude of analysts, build company development forecasts, and prepare data for reporting. It supports the full range of OLAP solutions - MOLAP (two types of Aggregate Storage and Block Storage), ROLAP and HOLAP (MOLAP + ROLAP).
The architecture can be schematically represented as follows:
')
It consists of the following components:
• Essbase Analytics Module (Block Storage)
This Analytic Services module creates a database based on the notion of a block - this is a table consisting of all possible variants of dense directions, and these blocks are located at the intersection of discharged directions. This module supports the recording of values using custom applications and is intended for integrated financial analysis.
Created for
- For applications related to iterative planning, distributions, complex analysis (sales analysis, profitability analysis)
- If you need a lot of procedural calculations and write changes to any level of aggregation
- Management of measurement calculation order
- Calculation of all or part of the database
- Perform complex calculations
• Enterprise Analytics Module (ASO Aggregate Storage)
This Analytic Services module creates an “aggregated” database, stores elements of zero level in itself, automatically calculating all values of a higher level, in its structure resembles ROLAP in its structure. Designed for the analysis of very large data (extremely discharged), with millions of possible indicators.
Created for
- For large, sparse data
- Standard Set of Aggregation Rules
• Analytic Administration Services administrative console
This is the Analytic Services database administrator interface that supports a single administration point for multiple database servers. Using this tool, you can develop, maintain and manage both servers and applications and their databases.
• Integration Console - Essbase Integration Studio (not developed, the predecessor of Essbase Integration Studio)
Integration Server is a server that uses a multi-threaded architecture, serving communication between relational data sources, an OLAP metadata catalog, and an Analytic Server (a multidimensional database server).
• Essbase SpreadSheat Add-in for Excel
This software solution is designed to receive AD-HOC reports in Microsoft Excel, it is directly connected to the multidimensional database. Development is stopped.
• Smart View for Office
Allows you to access data from the entire package of Microsoft Office, differs from Essbase SpreadSheet technological solution. Intensively developing.
• EssCMD
The command line interface is designed for administrative tasks, such as stopping an application, starting service utilities, backing up, etc.
• MaxL DDL
Command line interface for administrative tasks.
• Essbase API
This software developer tool allows you to access a multidimensional database from VB, C, or JAVA.
• Maintenance Services - Analytic Deployment Services
Allows you to build a single entry point for load balancing and fault tolerance between user applications and multidimensional databases.
Well, in the end there are several resources that will help in mastering this technology.
Oracle by Example
- Essbase Introduction
- Essbase Overview
- Creating Applications and Databases
- Working with outlines
- Loading Dimensions and Data
- Calculating Data
- Analyzing Data
- Essbase ASO Overview
Configure Essbase for those who are in the tank
Source: https://habr.com/ru/post/113322/
All Articles