Several optional products, designed to extend and enhance the scope of OLAP applications, can be addressed using the Hyperion Essbase server. The following sections describe these products.
Hyperion Essbase Spreadsheet Toolkit includes over 20 macro and Visual Basic for Applications (VBA) functions that enable you to build customized Microsoft Excel and Lotus 1-2-3 applications. The applications incorporate Hyperion Essbase commands. Commands such as EssCascade, EssConnect, and EssDisconnect provide all of the functionality of their corresponding Hyperion Essbase menu commands. For more information, see the Hyperion Essbase Spreadsheet Add-in online help.
Hyperion Essbase Partitioning option enables you to define areas of data that are shared or linked between data models. Partitioning can affect the performance and scalability of Hyperion Essbase applications. Partitioning provides more effective response to organizational demands, reduced calculation time, increased reliability and availability, and incorporation of detail and dimensionality. For more information, see Accessing Linked Partitions"Accessing Linked Partitions" on page 204.
Hyperion Essbase SQL Interface enables access to PC and structured query language (SQL) relational databases by making the Hyperion Essbase server operate as an open database connectivity client. Using Hyperion Essbase SQL Interface, data can be moved easily from these diverse corporate data sources into the Hyperion Essbase server for user access and analysis. For more information, see the Hyperion Essbase SQL Interface Guide.
Hyperion Essbase Application Programming Interface (API) enables application developers to create custom applications quickly by using standard tools while taking advantage of the robust data storage, retrieval, and manipulation capabilities of Hyperion Essbase. Hyperion Essbase API supports Visual Basic and C. For more information, see the online API Reference.
Hyperion Essbase Currency Conversion translates, analyzes, and reports on foreign financial data. Any exchange rate scenario can be modeled, and you can even perform ad hoc currency conversions of data directly from the spreadsheet. The Currency Conversion product is compliant with Financial Accounting Standards Board 52 (FASB52). For more information, see Working with Currency Conversions"Working with Currency Conversions" on page 216.
Hyperion Integration Server works with Hyperion Essbase and Microsoft Excel and Lotus 1-2-3. Hyperion Integration Server is a suite of tools and data integration services that serve as a bridge between relational data sources and Hyperion Essbase OLAP Server. Hyperion Integration Server Drill-Through is one of the tools of Hyperion Integration Server. Using Drill-Through, you can view and customize spreadsheet reports that display data retrieved from relational databases. For more information, see Using Hyperion Integration Server Drill-Through"Chapter 5. Using Hyperion Integration Server Drill-Through"
Hyperion Objects are ActiveX controls that enable you to build application programs quickly and easily to access and manipulate data residing in Hyperion Essbase servers. You can combine objects with other controls in a visual design environment to construct new programs.
Hyperion Web Gateway is a multithreaded server application that enables high-speed, interactive, read/write access to Hyperion Essbase for OLAP applications over the World Wide Web. Combining Hyperion Essbase with Hyperion Web Gateway provides a comprehensive Web-based solution that delivers sophisticated management reporting, provides ad hoc multidimensional analysis, and enables development of comprehensive operational OLAP applications, including planning, budgeting, and forecasting over intranets or the Internet.