Essbase can be used in many different applications. Financial analysts have found the product to be invaluable in budget analysis, currency conversion, and consolidation. Cost accountants apply its powerful capabilities to evaluate allocation and elimination scenarios. Product managers and analysts use it to plan and analyze multiple product lines and distribution channels. You can also use the product as a repository database for spreadsheet data. Anyone who uses a spreadsheet is a potential user of Essbase.
Because Essbase is applicable to such a broad variety of environments, individuals using it at an organization may fill one or more roles in implementing and running applications. This guide refers to specific roles by three titles. A role may be performed, however, by one person or by several people working collaboratively.
System administrator— Typically has experience in networking, installing software packages, and administering system functions. In addition to installing the Essbase software, the Essbase system administrator may also set up Essbase user accounts, set up the security system, and maintain the Essbase Server.
Application designer—Sets up the Essbase database, creates the database outline, and develops calculation and report scripts. The responsibilities of the Essbase system administrator and the application designer may overlap in some areas. The application designer has probably developed spreadsheet or database applications and understands the operational problems and the tools being employed to solve them.
User—Interacts with Essbase databases through spreadsheets, using Microsoft Office Excel (Excel). Users are typically analysts and managers who use spreadsheet programs as their primary tool for viewing and analyzing data.