Essbase ("extended spreadsheet database") is a multidimensional database management system that provides a database platform for building analytic applications.
- Developers
- Country of Origin
- US
- Start Year
- 1992 [05]
- Acquired By
- Project Type
- Commercial
- License
- Proprietary
Essbase ("extended spreadsheet database") is a multidimensional database management system that provides a database platform for building analytic applications.
Query Interface[03][04]
Essbase exposes a multidimensional query interface centered on the MDX (Multidimensional Expressions) language, which is used to query, analyze, and export data and metadata from cubes. Applications typically interact with Essbase through MDX over the XML for Analysis (XMLA) protocol. Users issue queries via Oracle Smart View, an Excel add-in that provides ad hoc grid retrieval and MDX execution from within spreadsheets. Users can also use MaxL scripts and other MDX-capable clients to embed cube queries into analytic workflows.
Citations
6 sources- Essbase | Oracle oracle.com
- Essbase - Wikipedia wikipedia.org
- MDX Queries oracle.com
- Select and load Essbase data | Qlik Connectors Help qlik.com
- Back to the Future - Oracle Essbase - Then and Now | PDF slideshare.net
- Enterprise Performance Management | Oracle oracle.com