tailieunhanh - Oracle Essbase 9 Implementation Guide- P43

Oracle Essbase 9 Implementation Guide- P43: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 Steps to Execute MaxL from the EAS Editor 1. Within EAS click on File Editor MaxL Script Editor. 2. The MaxL editor will be opened. 3. Variables can be defined at the Server Database and Application level. Create variables at the server level Server level variables can be created by the use of alter statement. Syntax ALTER SYSTEM ADD SET DROP VARIABLE variable-name Name of the variable string Value for the variable Example Create Variable alter system add variable varSystem 200801 Edit Variable alter system set variable varSystem 200802 Delete Variable alter system drop variable varSystem Create variables at the application level Using the alter command at the application level we can create edit or delete a substitution variable. Syntax ALTER APPLICATION APPLICATION-NAME ADD SET DROP VARIABLE variable-name Name of the variable string Value for the variable Example Create Variable alter application ESSCAR add variable varAppl ESSCAR1 Edit Variable alter application ESSCAR set variable varAppl ESSCAR Delete Variable alter application ESSCAR drop variable varAppl ---------------------------------- 195 --------------------------------- Download at Calculating your Essbase Cube Create variables at the database level Using the alter command at the database level we can create edit or delete a variable. Syntax ALTER DATABASE ADD SET DROP VARIABLE variable-name Name of the variable string Value for the variable Example Create Variable alter database add variable varAppDB ESSCAR1 Edit Variable alter application ESSCAR set variable varAppDB ESSCAR Delete Variable alter application ESSCAR drop variable varAppDB Using Maxl if you want to create a variable which has a double quote in it define it as shown below alter database ESSCAR . ESSCAR add variable varDQ TestDQ Displaying the Substitution Variable and its value To display a substitution variable the display MaxL statement will be used. Syntax display .