tailieunhanh - Oracle Essbase 9 Implementation Guide- P45

Oracle Essbase 9 Implementation Guide- P45: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 5 Well now that you know how to code a basic Essbase Command Script we will describe the various methods for executing it. They are as follows 1. EssCmd Drag and Drop Your client software should have come with a file called . If you have this file it will be located wherever your Essbase client software was installed. On a Windows machine the path is typically C Hyperion AnalyticServices bin. All you need to do is create a desktop shortcut to this executable file then drag any file onto the shortcut and the script will execute. If you do not have the file on your machine you can always get it from the Essbase Bin folder on your Essbase analytic server. 2. DOS Command Line All you need to do is navigate to the DOS command prompt from your desktop. Then type in a typical command line action at the command prompt. This will tell Windows to run the with the Gross Stock EssCmd script 3. Shell Command in Code You can easily use the Shell function in code to run your EssCmd Essbase Command Scripts. The Shell function can be used in languages like Microsoft Visual Basic or Microsoft Visual Basic for Applications to name a few Shell vbNormalFocus If you register the on your PC like you would register any DLL using the regsvr32 function you will be able to call the in a command line or shell command without having to include the entire path in the command. This is particularly useful to know because the itself only accepts paths with a length of upto 128 characters. Running a Calculation Script using a MaxL Script Here we have another command scripting facility for you to use to automate functionality in Essbase. The MaxL command script operates in much the same way as the EssCmd script although MaxL is supposed to be a much easier and more efficient scripting language. While the EssCmd scripting language has been around since the earliest versions