Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Essbase 9 Implementation Guide- P53:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Chapter 7 4. In the Add-Ins screen you should see the Hyperion Essbase OLAP Server DLL non Unicode selected. Now click OK on the Add-Ins screen. 5. You should see Essbase menu in Microsoft Excel as shown in the following screenshot That s it You now have the Essbase Add-in for Microsoft Excel installed loaded and ready to use. When you click on the Essbase menu pick from Microsoft Excel s main toolbar you will have approximately two dozen choices. There are a couple of choices that we feel must be explained without regard to the order of their appearance on the menu. However for the most part we will be starting at the top and working our way to the bottom of the menu. The Essbase menu looks like the following screenshot with all of the choices available. Please note that the order in which they appear is somewhat different than the order in which we will be discussing them. 245 Download at Boykma.Com Getting the most out of the Microsoft Excel Add-in Connecting to Essbase Obviously connecting to the Essbase database is one of the first tasks you should perform. Otherwise there isn t much you can do except the regular old boring Microsoft Excel tasks. To establish a connection to the appropriate Essbase database simply follow the steps here. Connecting to Essbase from Microsoft Excel What could be easier than connecting to your Essbase database right from your favorite data analysis tool Does it get any better Once you become familiar with the Essbase Add-in for Microsoft Excel and all of its myriad features we just know you will agree. 1. From the Microsoft Excel main menu bar click on Essbase Connect. 2. The Essbase System Login screen will appear as shown 3. Enter the appropriate Server name your Username and the Password assigned to your ID. Once completed click OK. 4. If your password has expired the system will inform you of that fact and allow you to choose a new password. You may also change your password at any time by clicking on the Change Password .
