GetWiki
Essbase
ARTICLE SUBJECTS
being →
database →
ethics →
fiction →
history →
internet →
language →
linux →
logic →
method →
news →
policy →
purpose →
religion →
science →
software →
truth →
unix →
wiki →
ARTICLE TYPES
essay →
feed →
help →
system →
wiki →
ARTICLE ORIGINS
critical →
forked →
imported →
original →
Essbase
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{short description|Database management system}}{{ad|date=February 2023}}- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
factoids | |
---|---|
History and motivation
Essbase was originally developed to address the scalability issues associated with spreadsheets such as Lotus 1-2-3 and Microsoft Excel. Indeed, the patent covering (now expired) Essbase uses spreadsheets as a motivating example to illustrate the need for such a system.Earle, Robert J. (1992) "Method and apparatus for storing and retrieving multi-dimensional data in computer memory" {{Webarchive|url=https://web.archive.org/web/20180201075154weblink |date=2018-02-01 }}. United States Patent 5,359,724 assigned to Arbor Software Corporation.In this context, "multi-dimensional" refers to the representation of financial data in spreadsheet format. A typical spreadsheet may display time intervals along column headings, and account names on row headings. For example:{| class="wikitable" style="text-align:center"! !! Jan !! Feb !! Mar !! TotalSparsity
As the number and size of dimensions increases, developers of multidimensional databases increasingly face technical problems in the physical representation of data. Say the above example was extended to add a "Customer" and "Product" dimension:{| class="wikitable" style="text-align:center"! Dimension !! Number of dimension valuesAggregation
OLAP systems generally provide for multiple levels of detail within each dimension by arranging the members of each dimension into one or more hierarchies. A time dimension, for example, may be represented as a hierarchy starting with "Total Time", and breaking down into multiple years, then quarters, then months. An Accounts dimension may start with "Profit", which breaks down into "Revenue" and "Expenses", and so on.In the example above, if "Product" represents individual product SKUs, analysts may also want to report using aggregations such as "Product Group", "Product Family", "Product Line", etc. Similarly, for "Customer", natural aggregations may arrange customers according to geographic location or industry.The number of aggregate values implied by a set of input data can become surprisingly large. If the Customer and Product dimensions are each in fact six "generations" deep, then 36 (6 Ã 6) aggregate values are affected by a single data point. It follows that if all these aggregate values are to be stored, the amount of space required is proportional to the product of the depth of all aggregating dimensions. For large databases, this can cause the effective storage requirements to be many hundred times the size of the data being aggregated.Block storage (Essbase Analytics)
Since version 7, Essbase has supported two "storage options" which take advantage of sparsity to minimize the amount of physical memory and disk space required to represent large multidimensional spaces. The Essbase patent describes the original method, which aimed to reduce the amount of physical memory required without increasing the time required to look up closely related values. With the introduction of alternative storage options, marketing materials called this the Block Storage Option (Essbase BSO), later referred to as Essbase Analytics.Put briefly, Essbase requires the developer to tag dimensions as "dense" or "sparse". The system then arranges data to represent the hypercube into "blocks", where each block comprises a multi-dimensional array made up of "dense" dimensions, and space is allocated for every potential cell in that block. Sparsity is exploited because the system only creates blocks when required. In the example above, say the developer has tagged "Accounts" and "Time" as "dense", and "Region", "Customer", and "Product" as "sparse". If there are, say, 12,000 combinations of Region, Customer and Product that contain data, then only 12,000 blocks will be created, each block large enough to store every possible combination of Accounts and Time. The number of cells stored is therefore 192000 (4 Ã 4 Ã 12000), requiring under 2 GiB of memory (exact 1,536 MB), plus the size of the index used to look up the appropriate blocks.Because the database hides this implementation from front-end tools (i.e., a report that attempts to retrieve data from non-existent cells merely sees "null" values), the full hypercube can be navigated naturally, and it is possible to load values into any cell interactively.Calculation engine
Users can specify calculations in Essbase BSO as:- the aggregation of values through dimensional hierarchies;
- stored calculations on dimension members;
- "dynamically calculated" dimension members; or
- procedural "calculation scripts" that act on values stored in the database.
Aggregate storage (Enterprise Analytics)
Although block storage effectively minimizes storage requirements without impacting retrieval time, it has limitations in its treatment of aggregate data in large applications, motivating the introduction of a second storage engine, named Aggregate Storage Option (Essbase ASO) or more recently, Enterprise Analytics. This storage option makes the database behave much more like an OLAP database, such as SQL Server Analysis Services.Following a data load, Essbase ASO does not store any aggregate values, but instead calculates them on demand. For large databases, where the time required to generate these values may become inconvenient, the database can materialize one or more aggregate "views", made up of one aggregate level from each dimension (for example, the database may calculate all combinations of the fifth generation of Product with the third generation of Customer), and these views are then used to generate other aggregate values where possible. This process can be partially automated, where the administrator specifies the amount of disk space that may be used, and the database generates views according to actual usage.This approach has a major drawback in that the cube cannot be treated for calculation purposes as a single large hypercube, because aggregate values cannot be directly controlled, so write-back from front-end tools is limited, and complex calculations that cannot be expressed as MDX expressions are not possible.Calculation engine
Essbase ASO can specify calculations as:- the aggregation of values through dimensional hierarchies; or
- dynamically calculated dimension members.
User interface
The majority of Essbase users work with Essbase data via an add-in for Microsoft Excel (previously also Lotus 1-2-3) known as Smart View. The Essbase Add-In is a standard plugin to Microsoft Excel and creates an additional menu that can be used to connect to Essbase databases, retrieve or write data, and navigate the cube's dimensions ("Zoom in", "Pivot", etc.).Hyperion Solutions Corporation (2006). Essbase Database Administrator's Guide. {{Webarchive|url=https://web.archive.org/web/20060204085022weblink |date=2006-02-04 }}In 2005, Hyperion began to offer a visualization tool called Hyperion Visual Explorer (HVE) which was an OEM from Tableau Software. Tableau Software originated at Stanford University as a government-sponsored research project to investigate new ways for users to interact with relational and OLAP databases. Hyperion and Tableau together built fundamentally the first versions of Tableau Software which was designed specifically for multidimensional (OLAP) databases. Oracle quickly terminated the OEM arrangement with Tableau Software soon after the acquisition of Hyperion in 2007.Most other well known analytics vendors provide user-facing applications with support for Essbase and include;- Hyperion Analyzer (aka Hyperion System 9 BI+ Web Analysis)
- Hyperion Reports (aka Hyperion System 9 BI+ Financial Reporting)
- Hyperion Enterprise Reporting
- Hyperion Business Intelligence (aka Hyperion System 9 BI+ Interactive Reporting, and Brio Interactive Reporting)
- Hyperion SQR (aka Hyperion System 9 BI+ Production Reporting)
- Alphablox
- Arcplan dynaSight (aka Arcplan Enterprise)
- Oracle Business Intelligence Suite Enterprise Edition (aka OBIEE, Siebel Analytics)
- Dodeca Spreadsheet Management SystemWEB, Applied OLAP: Dodeca Spreadsheet Management System Software,weblink DodecaSpreadsheet Management System, Applied OLAP, Inc.,
- Dodeca Excel Add-In for EssbaseWEB,weblink Dodeca Excel Add-In for Essbase,
- Reporting SuiteWEB,weblink Homepage -, 2018-09-06,weblink" title="web.archive.org/web/20130422094749weblink">weblink 2013-04-22, dead,
- EV AnalyticsWEB,weblink Self-service data analysis with cubus EV,
Administrative interface
A number of standard interfaces can administer Essbase applications:- ESSCMD, the original command line interface for administration commands;
- MaxL, a "multi-dimensional database access language" which provides both a superset of ESSCMD commands, but with a syntax more akin to SQL, as well as support for MDX queries;
- Essbase Application Manager, the original Microsoft Windows GUI administration client, compatible with versions of Essbase before 7.0;
- Essbase Administration Services, later renamed Analytic Administration Services, and then back to 'Essbase Administration Services' in v. 9.3.1, the currently supported GUI administration client; and
- Essbase Integration Server for maintaining the structure and content of Essbase databases based on data models derived from relational or file-based data sources.
Cloud offerings
Since 2017, Essbase Cloud has been available as part of the Oracle Analytics Cloud (OAC), a suite of analytics that include reports and dashboards, data visualization, inline data preparation and mobile.WEB,weblink Oracle Essbase Cloud is Here, Todd Rebner, April 19, 2017, Datavail Corporation,Competitors
There are several significant competitors among the OLAP, analytics products to that of Essbase (HOLAP/MOLAP) on the market, among them SAP BPC, Microsoft SQL Server Microsoft Analysis Services, (MOLAP, HOLAP, ROLAP), IBM Cognos (ROLAP), IBM/Cognos/Applix TM1 (MOLAP), Oracle OLAP (ROLAP/MOLAP), MicroStrategy (ROLAP), and EXASolution (ROLAP).Also note that of the above competitors, including Essbase, all use heterogenous relational (Microsoft SQL Server, Oracle, IBM DB/2, TeraData, Access, etc.) or non-relational data sourcing (Excel, text Files, CSV Files, etc.) to feed the cubes (facts and dimensional data), except for Oracle OLAP which may only use Oracle relational sourcing.Export and/or product migration of Essbase
{{As of | 2009}} two options can export Essbase cubes into other formats:- CubePort, a commercial conversion application, converts Essbase cubes to the Microsoft SQL Server Analysis Services product. This product performs an object-to-object translation that make up an Essbase cube, including: outline, member formulas, calc scripts, data loading (load rules), report scripts to MDX queries, substitution variables, and security model. It can extract from any platform version of Essbase, including Oracle/Hyperion Essbase on Windows, Unix, AIX, HP UX, Solaris, IBM DB/2 OLAP, or AS/400 Showcase Essbase.
- OlapUnderground Outline Extractor performs a pure, rudimentary, export of the outline, though it does not directly create any new objects. The output is a simple text file that can be pulled indirectly into other OLAP products, among other uses, such as synchronizing outlines.
See also
References
External links
{{Oracle}}- content above as imported from Wikipedia
- "Essbase" does not exist on GetWiki (yet)
- time: 6:05pm EDT - Wed, May 01 2024
- "Essbase" does not exist on GetWiki (yet)
- time: 6:05pm EDT - Wed, May 01 2024
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 23 MAY 2022
The Illusion of Choice
Culture
Culture
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GetMeta:About
GetWiki
GetWiki
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
Biographies
GETWIKI 20 AUG 2014
GetMeta:News
GetWiki
GetWiki
© 2024 M.R.M. PARROTT | ALL RIGHTS RESERVED