Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Essbase 9 Implementation Guide- P64: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. | Automating your Essbase Cube CALCDEFAULT Executes the default calculation on the selected database IFERROR ERROR On an error the script will branch to the ERROR line UNLOADDB appName dbName Unloads the specified database from memory IFERROR ERROR On an error the script will branch to the ERROR line UNLOADAPP appName Unloads the specified application from memory IFERROR ERROR On an error the script will branch to the ERROR line Now let s add these lines to the rest of the script and see what a complete EssCmd script looks like. The finished script Here is what your EssCmd script should look like with all of the commands added. It is ready to execute and in the next section we will discuss the ways to execute an Essbase Command script. OUTPUT 1 c EssCmd.log The 1 specifies turning job log output on and then you code the log s location IFERROR ERROR On an error the script will branch to the ERROR line LOGIN hostNode userName password Connect to Essbase server IFERROR ERROR On an error the script will branch to the ERROR line SELECT appName dbName Connect to specific application database IFERROR ERROR On an error the script will branch to the ERROR line LOADAPP appName Loads the specified application into memory IFERROR ERROR On an error the script will branch to the ERROR line LOADDB appName dbName Loads the specified database into memory IFERROR ERROR On an error the script will branch to the ERROR line 300 Download at Boykma.Com Chapter 8 CALCDEFAULT Executes the default calculation on the selected database IFERROR ERROR On an error the script will branch to the ERROR line UNLOADDB appName dbName Unloads the specified database from memory IFERROR ERROR On an error the script will branch to the ERROR line UNLOADAPP appName Unloads the specified application from memory IFERROR ERROR On an error the script will branch to the ERROR line OUTPUT 3 Turns off script logging LOGOUT Logs out the script and exits ERROR Script branches to here and resumes execution on error .
