ESSBASE——ESSCMD整理

     ESSCMD is a command-line interface that performs operations interactively or through a batch or script file. You can execute server operations at the

command line, in either batch or interactive mode.
    命令行，交互，批处理。
    通过命令行来进行交互操作。
-----------------------------------------------------------------------------------------------------------------------------
    Interactive mode lets you interactively enter commands at the ESSCMD command line and receive responses. Interactive mode is convenient for short

operations that require few commands, checking for information on the fly, and error checking.
    交互模式
-----------------------------------------------------------------------------------------------------------------------------
    Batch processing mode lets you automate your routine server maintenance and diagnostic tasks. You can write a script or batch file and run it from the

command line. Batch processing mode is convenient if you frequently use a particular series of commands, or if your task requires many commands.
    批处理模式
-----------------------------------------------------------------------------------------------------------------------------
Interactive mode
    Quotation marks (" ") enclose character parameters and responses to commands.
    " "把参数与响应封装到命令里。

    Quotation Marks（引号规则）
    In interactive ESSCMD, using quotes is optional. Be sure to use quotes when a parameter has an embedded space; for example,
CALC "Calc All;"
    使用" " 是可选择性的，但在有空可得参数就必须用" "。

    In an ESSCMD script file, always enclose all character parameters and responses to commands in quotes; for example,
LOGIN "Local" "TomT" "Password";
    尽可能使用" "把参数与响应封装在命令里。

    You do not have to enclose numeric parameters and responses in quotes.
    对于数据型参数和响应，必须使用" "。

    You cannot place quotes within quotes.
    " "不允许嵌套。
   
    Semicolon Statement Terminator(分号;规则)
    The ; (semicolon) statement terminator signals the end of a command; for example,
    SELECT "SAMPLE" "BASIC";

    In interactive ESSCMD, pressing the Enter key signals ESSCMD that the command is complete. The statement terminator is optional.
    在一条命令结束时按回车.

    In an ESSCMD script file, you should use the terminator, even though it is optional, if a command has many parameters. This is especially important in

order to signal the end of the parameter list if some of the parameters are optional. 
    当有多个参数时,一定要终结命令.

    If you omit some optional parameters and do not use ; to end the list, ESSCMD looks for the remaining values in the next command in the file, leading to

unpredictable results.
   
    Referencing Files
    Some commands require that you precede object or file names with a numeric parameter, from 1 to 4, that tells Hyperion Essbase where to look for the

object or file. The parameter directs ESSCMD to look for files in other applications, databases, or systems.
    有些命令要求之前提供带有数字参数的对象或文件名.数字从1到4,这告诉ESSBASE从哪里找到这些对象或文件.

   numeric  File
    1  Local or client-base file  
     2  Remote or server-base file
     3  File
     4  SQL table
   
=============================================================================================================================
-----------------------------------------------------------------------------------------------------------------------------
命令分类:
Using ESSCMD(ESSCMD的使用)
 LOGIN (登录)   SELECT (选择APP或DB)
 LOGOUT (退出登录)  HELP
 LISTLOGINS (登录列表)  SETHELP
 SETLOGIN (登录设置)  EXIT 
 SLEEP (休眠)
-----------------------------------------------------------------------------------------------------------------------------
Application and Database Administration (APP与DB管理)
 COPYAPP  GETAPPACTIVE GETDBSTATS LOADAPP  SETDBSTATE
 COPYDB  GDTAPPINFO GETVERSION LOADDB  SETDBSTATEINEM
 CREATEAPP GETAPPSTATE LISTAPP  RENAMEAPP SHUTDOWNSERVER
 CREATEDB GETDBACTIVE LISTDB  RENAMEDB UNLOADAPP
 DELETEAPP GETDBINFO LISTFILES SETAPPSTATE UNLOADDB
 DELETEDB GETDBSTATE
-----------------------------------------------------------------------------------------------------------------------------
User/Group Security (用户/组安全)
 DISABLELOGIN DELETEUSER CREATEGROUP LISTGROUPUSERS
 ENABLELOGIN RENAMEUSER DILETEGROUP 
 LOGINOUTUSER LISTUSERS LISTGUOUPS
 LOGINALLUSERS GETUSERINFO ADDUSER
 CREATEUSER SETPASSWORD REMOVEUSER
-----------------------------------------------------------------------------------------------------------------------------
Security Filters and Locks (过滤与锁)
 COPUFILTER REMOVELOCKS
 LISTFILTERS RENAMEFILTER
 LISTLOCKS
-----------------------------------------------------------------------------------------------------------------------------
Database Objects (数据库对象)
 LISTOBJECTS LISTLINKEDOBJECTS
 COPYOBJECT PURGELINKEDOBJECT
 RENAMEOBJECT
 UNLOCKOBJECT
-----------------------------------------------------------------------------------------------------------------------------
OUTLINE/ATTRIBUTE INFOMATION

=============================================================================================================================
-----------------------------------------------------------------------------------------------------------------------------
命令参考：

SETAPPSTATE：The SETAPPSTATE command defines application settings.
语法：SETAPPSTATE ["appName"] "desc" Y/N Y/N accessLevel Y/N Y/N Y/N Y/N lockTimeout       MaxLROFileSize;
参数： application的名字。
 desc: application描述。
 Y/N: 是否application可装载。
 Y/N： 是否自动装载。
 accessLevel: 访问级别。0-none 1-read 2-write 3-calculate 4-application designer
 Y/N: 是否已建立连接。
 Y/N: 
 Y/N: 是否能更新。
 Y/N: 是否激活安全机制。
 LockTimeout: 锁定超时(单位:秒)
 MaxLROFileSize: 设置文件大小

登录类命令:
 LOGIN
 LOGINOUT

选择类命令:
 SELECTG APPNAME DATABASE

显示类:
 LIST*

属性类:
 GETAPPACTIVE
  显示当前活动APP.
 GETAPPINFO
  显示当前APP信息.
 GETAPPSTATE
  显示当前APP状态.
 GETDBSTATE
  显示当前数据库状态.
 GETDBSTATES
 GETALLREPLCELLS

 GETAPPACTIVE
 GETAPPINFO
 GETAPPSTATE
 GETATTRIBUTESPECS
 GETATTRINFO
 GETCRDB
 GETCRDBINFO
 GETCRRATE
 GETCRTYPE
 GETDBACTIVE
 GETDBINFO
 GETDBSTATE
 GETDBSTATS
 GETDEFAULTCALC
 GETMBRCALC
 GETMBRINFO
 GETMEMBERS
 GETPARTITIONOTLCHANGES
 GETPERFSTATS
 GETUPDATEDREPLCELLS
 GETUSERINFO
 GETVERSION

创建类:
 CREATEAPP
  CREATEAPP APPNAME
 CREATEDB
  CREATEDB APPNAME DATABASE

=============================================================================================================================
重点掌握:
命令: BUILDDIM  (**********)
描述: Use the BUILDDIM command to dynamically build one or more dimensions from a data file or SQL source.
 建维命令
     This command builds one or more dimensions from a data file or an SQL source. Many applications have large   dimensions that are

impractical to manually define and maintain. This command makes it possible to automate the   dimension-building and  updating processes. See the

INCBUILDDIM command for another way to build dimensions.
 自动建立维度并自动更新数据.
语法: BUILDDIM location rulobjName dataLoc sourceName fileType errorLog
事例: BUILDDIM 1 "PROD" 1 "PRODUCTS" 4 "PRODERR";
-----------------------------------------------------------------------------------------------------------------------------
命令: CALC
描述: The CALC command executes one or more calculation strings.
 In interactive ESSCMD, you can enter multiple strings, one at a time.
语法: CALC "calcString; [calcString;]"
事例: CALC "SJ;ACCOUNTS;";
-----------------------------------------------------------------------------------------------------------------------------
命令: CALCDEFAULT
描述: The CALCDEFAULT command calculates the default database calculation.
语法: CALCDEFAULT
事例: CALCDEFAULT;
-----------------------------------------------------------------------------------------------------------------------------
命令: BEGININCBUILDDIM
描述: The BEGININCBUILDDIM command prepares Hyperion Essbase for upcoming incremental  dimension-building commands.
语法: BEGININCBUILDDIM
事例: To build the dimensions specified in GENREF.RUL and LEVELMUL.RUL, discard all data,  and save the new outline after the dimension builds are

complete:

 BEGININCBUILDDIM;
 INCBUILDDIM 2 "GENREF.RUL" 2 "GENREF.TXT" 4 "ERR.OUT" 1;
 INCBUILDDIM 2 "LEVELMUL.RUL" 2 "LEVELMUL.TXT" 4 "ERR.OUT" 1;
 ENDINCBUILDDIM 4;
-----------------------------------------------------------------------------------------------------------------------------
命令： 

-----------------------------------------------------------------------------------------------------------------------------