Oracle Essbase is a powerful OLAP (Online Analytical Processing) Server. Essbase combines a highly advanced calculation engine, an easy-to-use development GUI and powerful scripting possibilities. This makes Essbase an ideal OLAP database for many purposes. Line-of-business personnel can be enabled to manage their OLAP Applications themselves, but IT can also schedule scripts to rebuild complete applications which can be refreshed daily.
Oracle Essbase offers very fast query response times for a vast number of concurrent users with its patented technology. Databases are typically pre-calculated to a certain extent so queries are delivered in a “speed-of-thought” to a wide array of client tools. Next to a strong Microsoft Office integration with Smart Tags, Essbase supports many other reporting tools with its open standard Java OLAP Interface, Essbase API and the query language MDX.Essbase offers a block storage, aggregate storage and hybrid storage model – each tailored to best fit the requirements.
The block storage model offers write-back capabilities at all levels in the database and is used as the data container in Oracle Hyperion Planning. This data storage makes the application a true MOLAP type database with powerful calculation engine including hundreds of out-of-the-box functions.
The aggregate storage model has all the advantages of a ROLAP type database, supporting many and very large dimensions, while keeping the performance similar to a fully calculated database. Straightforward aggregations are created in seconds and analysis work can start instantly. Calculations and queries can be created using the open standard of Multidimensional Expressions (MDX).
The hybrid storage model combines the strengths of BSO and ASO into a cube and is now the standard in Oracle Analytic Cloud Service (Essbase in the cloud).
Essbase traditionally supports both 32 and 64 bit computing across many operating environments including Windows, Solaris, AIX, HP-UX and Linux.
Trexco b.v. is specialized in delivering all kind of services on Essbase for you.