Contact Sales
ShowCase® Essbase® Features
Give your organization unrivaled analytic power.
There's a reason that Hyperion® Essbase is the industry-leading OLAP solution. It simply offers more features and functionality than any other solution. ShowCase Essbase brings these technologies to companies using the IBM® eServer iSeries™ (AS/400®).
With Essbase, your company's managers, executives and analysts can:
- Analyze even large, complex data sets quickly
- Move easily between summarized information and detailed data
- Employ familiar spreadsheet programs such as Microsoft® Excel and Lotus® 1-2-3® to arrange and analyze data
- Perform trend analysis and develop "what if" scenarios
- Carry out complex analyses, such as multi-currency financial translations and inter-departmental budget allocations, using sophisticated, built-in Essbase formulas
Your IT managers and project leaders can:
- Access data in legacy systems, online transaction processing (OLTP) systems, relational data warehouses, enterprise resource planning (ERP) systems and even spreadsheets to create multidimensional Essbase databases or "cubes"
- Include thousands of dimensions and attributes—up to a million members per dimension
- Modify databases to reflect changes in business structures and conditions
- Use custom-defined macros and functions to express both simple and complex relationships in your data
- Provide end users with rapid response times to queries, even if many users access the database simultaneously
Your System administrators can:
- Improve performance and maintain data integrity by hosting data, data model, calculations and data security controls on an iSeries server
- Simplify administrative functions by having your relational data warehouse and OLAP data marts on the same platform
- Manage user sessions so that system maintenance can be performed efficiently
New features available with Essbase include:
- More efficient database maintenance. If your organization uses an iSeries server equipped with multiple processors, you can achieve faster turnaround on batch operations, such as re-calculating the cube, thanks to this release’s enhanced parallel calculations feature and high-concurrency kernel.
- Essbase Integration Services (EIS). Your organization can maintain consistency among multidimensional databases and combine them more easily, through the use of EIS. Once you have created OLAP structures, you can reuse them, in part or in their entirety, to build additional cubes for other applications. This reduces the time and expense required to create, deploy and manage business applications. In addition, Essbase Integration Services acts as a "bridge" between Essbase data and detailed relational data.
- Hybrid analysis functionality. Your company’s business users can analyze relational data just as though it were loaded into an Essbase cube, thanks to hybrid analysis functionality. To take advantage of this feature, you simply map data from relational databases to appropriate hierarchies in multidimensional Essbase cubes. Hybrid analysis can save your company time both in building and in re-calculating cubes, and delivers greater analytic capabilities. Please note: Hybrid analysis functionality requires licensing the new Essbase Integration Server.
Here is information about system requirements for Essbase.
Contact Sales
