1. Double-click the setup file for Oracle Essbase. After installing the Java Runtime Environment and initializing the install wizard, you will be presented with a screen asking you to select a language to be used by the installation wizard. This is the language that the rest of the installation screens will display. We recommend English as it is the only choice available in the list box.
2. The next is the Oracle Essbase welcome screen, click Next whenever you are ready.
3. On the next screen, you are asked to select a country. Please select the appropriate country for your application, as this selection sets the country variable in the system. This country variable is used for currency calculations.
4. The next step is the license agreement screen, which you should read very carefully. When you have finished, select I AGREE, then click Next to proceed.
5. In this step, you need to specify the Hyperion home directory which defaults to c:\Hyperion. It is in this folder that all of the required and optional Essbase System 9 common components will be installed. If you choose to select a different path, please do so here.
6. In this step, you need to specify the Essbase server directory. If you do nothing, it will default to the home directory you selected in the previous step.
7. In this step, you are asked to select either the Typical or Custom installation. The Custom installation includes all of the components and allows you to pick which ones are required for your installation. We suggest you select the Typical installation for now as you can add other components at anytime in the future.
8. In this step, you are asking the wizard to update your system environment variables with the new Essbase system variables you have chosen in the previous two steps. The new environment variables, PATH and ARBORPATH, will be set in the system and the Essbase server configuration file. We will discuss this file and the settings later in the book. By default, the installer wizard is set to update the environment variables. Please leave it as is and click Next.
9. In this step, you are required to select the ESSLANG. The ESSLANG language variable defines the locale of the computer. For example, for US English, it is ENGLISH (LATIN1). This is to ensure proper communication with other applications and is the Unicode setting.
10. This step summarizes all of the components that are to be installed during this present installation. Check the information carefully to confirm you have the locations correct, as well as the selected Oracle Essbase components. If there are any corrections that need to be made, use the Back button to go back and fix what is needed. This is your last chance before the wizard begins the actual installation.
11. This step basically tells you that the Essbase installation is in progress. Take a break, read the install notes as they flash on the screen.
12. Upon successful installation, you are now asked if you want to launch the system configuration tool. The default is selected and it is recommended you use it now to confirm your configuration one more time.
13. Yes, another one of these screens. This is now the configuration tool wizard. You are again asked to select the language for the wizard. Even though it is part of the Essbase analytics server software, what the heck, you may want to use a different language. Select English or the system will select English for you. Once again, this will determine what language the installation screens are presented in.
14. On the screen below, you are presented with the Essbase System 9 components you have installed on your server and their configuration status. Place a check mark next to all of the components that are flagged as pending, as now is the best time to set up your components and verify their proper configuration. Looking at the following screenshot, you can see that all choices are pending. Since shared services has not been installed, you will only want to place a check on Essbase Server, Product Options and Register Analytic Services Server as Windows Service at this time.
Clicking Next will open screens to you which will walk you through the configuration steps for the components you’ve selected. This is also where you will enter your initial supervisor account ID and password, so make sure you do not forget it.
15. After successful installation and configuration, you will see the following screen. Congratulations! You now have a fully functioning Essbase service installed on your server, complete with full Essbase API functionality. See the next step for what to do at the initial start up.
16. After the successful installation of Essbase server, please click on the START | Programs | Hyperion | Essbase | Essbase to start the service for the very first time. You will be asked for the ID and password you supplied in the configuration tool for Essbase installation. When the service starts, you want to see the line on the following screen—Waiting for Client Requests….
Installing Essbase Administration Services
The EAS talks to the Essbase service using TCP/IP and a web-based server. The servers recommended by Oracle are Tomcat, WebLogic, WebSphere, and Oracle Application Server. To simplify matters, Oracle includes a small Tomcat server with the installation package of the EAS service. In our example, we will be installing Tomcat as our administration server on the client with the EAS installation:
1. To get started, double-click the EAS executable file setup which is supplied by Oracle. Wouldn’t you know that the very first screen to pleasure your eyes is the familiar old language selection screen. As always, this is where you select the language to be used with the installation wizard. Again, as always, select English as it is the only language option available. Click OK when you are ready.
2. As in the server software installation, you are now treated to the setup program welcome screen. Read this as you usually would and then click Next.
3. You may be noticing several similarities by now. This screen prompts you to select a country where, ideally, the software will be used.
4. This step asks you to read and agree to the End User License Agreement (EULA). Read it carefully, and if you agree and wish to continue, click Next.
5. This step will ask you to accept or select the location for the Hyperion home directory (folder). Even though this software is being installed on a different physical machine than the Essbase analytics, ideally, it is a good idea to always install to consistent locations across the individual machines involved in the construction of the system.
Make your selection and click Next.
6. Here, you are asked to select your path for EAS. As suggested in previous steps, make your selection and then click Next.
7. Here again, it will be best to accept the Typical installation to get you started. If you realize there is some feature missing that you must have, you can always reinstall the software at a later date and select the Custom option.
For the most part, the difference between the Typical and the Custom installation is the ability to select sample scripts. The actual Essbase administrative functionality is the same.
8. You need to select ESSLANG. The ESSLANG variable defines the locale of the computer. For example, for US English it is ENGLISH (LATIN1). This is to ensure proper communication with other applications and is the Unicode setting.
9. This step summarizes the current installation. Check the information carefully to confirm you have the locations correct as well as the selected Hyperion components. If there are any corrections to be made, use the Back button to go back and fix what is needed. This is your last chance before the wizard begins the actual installation.
10. This step basically tells you that the EAS installation is in progress.
11. Since you are only installing the EAS tool. Do not check the box on the screen labeled Launch Configuration Tool. Simply click Finish.
Starting the EAS
Your EAS tool requires the use of a web server to communicate with the Essbase agent on the analytic server. You can install EAS on a bona fide web server, but in this example, we will use the small web admin server included with the Essbase set up package. This small web server allows you to install the EAS directly on your client.
The starting of the Tomcat administration server and the EAS tool is a two step process:
1. Locate the admin server start executable (the location is dependent on system paths chosen by you during installation). The server executable is located in the Hyperion\EAS\Server\Bin path. Start the server by double-clicking the executable.
2. Locate the EAS console executable (again, the location is dependent on the installation paths you have chosen). This path is usually located in the Hyperion\EAS\Console\Bin path. Start the console by double-clicking on it.
When the EAS console opens, you will see the following screen. Initially you will need to supply the server name (network name of client), the default ID of admin, and the default password of password. It is highly recommended you immediately use the User Setup Wizard to create a supervisor account for yourself.
Connect to the Essbase server to test the installation. Using your mouse, right-click on Add Essbase Server. In the text boxes of the login screen, enter the Essbase server name as it is known on the network, the initial user ID (in our case Hypuser) and the initial password (ours is password, all lower case).
If your connection is successful, you will see the Essbase server listed in the left pane. You should be able to expand the server to see many options that are available.
In the next series of steps, we will install the Essbase Add-in for Microsoft Excel to complete the toolbox. Once that is accomplished, we will be ready to begin building and programming in Essbase.
Installing the Essbase Add-in for Microsoft Excel
We have installed Essbase analytic server and EAS and we are left only with the reporting tool.
1. To get started, double-click on the Essbase client executable file supplied by Oracle.Choose the language and click OK
2. This step welcomes you to the installation of the Essbase client software, also known as the Essbase add-in. As usual, there are some recommendations and warnings, please click Next after you finish reading it.
3. In this step, as we have suggested before, please select the same country that you have chosen in the Essbase analytics server and EAS installations. In case you have forgotten, keeping the country variable consistent across all installed components will make your life easier. Once done, please click Next.
4. This step asks to read and agree to the EULA. Read it carefully, and if you agree and wish to continue, click Next.
5. This step has already detected the Hyperion home directory from a previous installation. If your home directory is different, select your home directory and then click Next.
6. In this step, you are creating a directory for the Essbase client installation. Please choose c:\Hyperion and click Next when you are done.
7. We recommend that you select Typical and click Next. As stated earlier, the Typical installation gives you all of the tools included with the software. Choosing Custom will really only provide more choices for samples.
8. This step requires you to select ESSLANG. The ESSLANG variable defines the locale of the computer. Just like before, please feel free to select English.
9. This step summarizes all of the components required for the client installation as well as the path. Please look them over carefully. Most importantly, verify the path and that it is correct with consideration to the other components installed on this machine. Click Next when you are satisfied that everything is correct.
10. This steps shows that the Essbase client installation is in progress and we recommend you not to take any more coffee breaks since you have already taken a lot of breaks in the previous installations.
When the installation wizard finishes installing the software, the Next button will be enabled. Please click Next to continue.
11. This step tells you that the Essbase client installation is completed. Click Next when you are ready.
12. Now, open Microsoft Excel. As it loads you should briefly see a HYPERION ESSBASE SPREADSHEET ADD-IN splash screen (shown below). Once Microsoft Excel has finished loading, you should see a brand new menu pick named Essbase that is usually located between the Window pick and the Help pick. This tells you that the Essbase client is successfully installed.