![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Hyperion
Frequently-Asked Questions
Pour plus d'information au sujet de cette faq, contactez Jean-Louis BICQUELET
FAQ Revised: Friday 18 June 2010 16:34:51
batman:::essprod[1]->listapp ListApp: Applications available: ABDPRO12 AEPRO004 AEPRO003 AFAPRO02 AFAPRO03
GETAPPSTATE appli001 GetAppState: -------Application State------- Description : Allow Application to Start : Yes Start Application when Essbase Starts : No Access Level : None Allow Connects : Yes Allow Commands : Yes Allow Updates : Yes Security : Enable Lock Timeout : 3600 LRO file size limit : 0
GETAPPINFO appli001 GetAppInfo: -------Application Info------- Name : appli001 Server Name : batman Status : Loaded Elapsed App Time : 00:17:52:57 Users Connected : 9 Data Storage Type : Multidimensional Data Storage Number of DBs : 1 --List of Databases-- Database (0) : appli001
ESSCMD login serveur essbase mot_de_passe
essprod[1]->? Help: Detailed information for each of the ESSCMD commands listed can be found in the online Technical Reference documentation, located in the docs directory of your Essbase installation. ADDUSER APPLYOTLCHANGEFILE BEGINARCHIVE BEGININCBUILDDIM BUILDDIM CALC CALCDEFAULT CALCLINE COPYAPP COPYDB COPYFILTER COPYOBJECT CREATEAPP CREATEDB CREATEGROUP CREATELOCATION CREATEUSER CREATEVARIABLE DEFRAG DELETEAPP DELETEDB DELETEGROUP DELETELOCATION DELETELOG DELETEUSER DELETEVARIABLE DISABLELOGIN DISPLAYALIAS ENABLELOGIN ENDARCHIVE Press Enter for more... > ENDINCBUILDDIM ESTIMATEFULLDBSIZE EXPORT GETALLREPLCELLS GETAPPACTIVE GETAPPINFO GETAPPSTATE GETATTRIBUTESPECS GETATTRINFO GETCRDB GETCRDBINFO GETCRRATE GETCRTYPE GETDBACTIVE GETDBINFO GETDBSTATE GETDBSTATS GETDEFAULTCALC GETMBRCALC GETMBRINFO GETMEMBERS GETPARTITIONOTLCHANGES GETPERFSTATS GETUPDATEDREPLCELLS GETUSERINFO GETVERSION GOTO HELP IFERROR IMPORT INCBUILDDIM LISTALIASES LISTAPP LISTDB LISTFILES LISTFILTERS LISTGROUPS LISTGROUPUSERS LISTLINKEDOBJECTS LISTLOCATIONS LISTLOCKS LISTLOGINS LISTMEMBERS LISTOBJECTS LISTUSERS LISTVARIABLES LOADALIAS LOADAPP LOADDATA LOADDB LOGIN LOGOUT LOGOUTALLUSERS LOGOUTUSER OUTPUT Press Enter for more... > PAREXPORT PRINTPARTITIONDEFFILE PURGELINKEDOBJECTS PURGEOTLCHANGEFILE PUTALLREPLCELLS PUTUPDATEDREPLCELLS REMOVELOCKS REMOVEUSER RENAMEAPP RENAMEDB RENAMEFILTER RENAMEOBJECT RENAMEUSER REPORT REPORTLINE RESETDB RESETOTLCHANGETIME RESETPERFSTATS RESETSTATUS RUNCALC RUNREPT SELECT SETALIAS SETAPPSTATE SETDBSTATE SETDBSTATEITEM SETDEFAULTCALC SETDEFAULTCALCFILE SETHELP SETLOGIN SETMSGLEVEL SETPASSWORD SHUTDOWNSERVER SLEEP UNLOADALIAS UNLOADAPP UNLOADDB UNLOCKOBJECT UPDATE UPDATEFILE UPDATEVARIABLE VALIDATE VALIDATEPARTITIONDEFFILE Detailed information for each of the ESSCMD commands listed can be found in the online Technical Reference documenation, located in the docs directory of your Essbase installation.
getversion GetVersion: Hyperion Essbase OLAP Server - Version 6.5.1
listdb ListDb: -----Applications/databases available----- ABDGEB12 ==> Abdgeb12 AECO2004 ==> AECO2004 AECO2003 ==> Aeco2003 AFAR2002 ==> Afar2002 AFAR2003 ==> Afar2003 AFBUD04 ==> Afbud04 ANBALA02 ==> Anbala02 ANBALA03 ==> Anbala03 COMPTAT2 ==> Analytik Conso ==> Budget MIAGRICA ==> Miagrica MIAGRUNI ==> Miagruni MIBALDEV ==> Mibaldev MIBALFON ==> Mibalfon MIBALGEN ==> Mibalgen MIBG1P03 ==> Mibg1p03
getdbinfo GetDbInfo: Application name >appli001 Database name >appli001 ----- Database Information ----- Name : appli001 Application Name : appli001 Database Type : NORMAL Status : Loaded Elapsed Db Time : 00:17:24:47 Users Connected : 3 Blocks Locked : 0 Dimensions : 6 Data Status : Data has been modified since last calculation. Data File Cache Size Setting : 0 Current Data File Cache Size : 0 Data Cache Size Setting : 3055104 Current Data Cache Size : 3055104 Index Cache Size Setting : 1048576 Current Index Cache Size : 1048576 Index Page Size Setting : 8192 Current Index Page Size : 8192 Cache Memory Locking : Disabled Database State : Read-only Data Compression on Disk : Yes Data Compression Type : BitMap Compression Retrieval Buffer Size (in K) : 10 Retrieval Sort Buffer Size (in K) : 10 Isolation Level : Uncommitted Access Pre Image Access : No Time Out : Never Number of blocks modified before internal commit : 3000 Number of rows to data load before internal commit : 0 Number of disk volume definitions : 0 --Currency Info-- Currency Country Dimension Member : Currency Time Dimension Member : PERIODES Currency Category Dimension Member : CONSOLIDATION Currency Type Dimension Member : Currency Partition Member : --Request Info-- Request Type : Data Load User Name : appli001 Start Time : Wed Jun 9 15:05:08 2010 End Time : Wed Jun 9 15:05:37 2010 Request Type : Customized Calculation User Name : appli001 Start Time : Wed Jun 9 14:15:50 2010 End Time : Wed Jun 9 15:05:07 2010 Request Type : Outline Update User Name : c_lacombep Start Time : Thu May 27 16:04:39 2010 End Time : Thu May 27 16:04:45 2010
GETDBSTATE appli001 GetDbState: Database name >appli001 ---------Database State--------- Description: Allow Database to Start : Yes Start Database when Application Starts : Yes Access Level : None Data File Cache Size : 33554432 Data Cache Size : 3145728 Aggregate Missing Values : No Perform two pass calc when [CALC ALL;] : Yes Create blocks on equation : No Currency DB Name : N/A Currency Conversion Type Member : N/A Currency Conversion Type : N/A Index Cache Size : 1048576 Index Page Size : 8192 Cache Memory Locking : Disabled Data Compression on Disk : Yes Data Compression Type : BitMap Compression Retrieval Buffer Size (in K) : 10 Retrieval Sort Buffer Size (in K) : 10 Isolation Level : Uncommitted Access Pre Image Access : Yes Time Out after : 20 sec. Number of blocks modified before internal commit : 3000 Number of rows to data load before internal commit : 0 Number of disk volume definitions : 0 I/O Access Mode (pending) : Buffered I/O Access Mode (in use) : Buffered Direct I/O Type (in use) : N/A lassie:::essprod[1]->GETDBSTATE GetDbState: Application name >appli001 Database name >appli001 ---------Database State--------- Description: Allow Database to Start : Yes Start Database when Application Starts : Yes Access Level : None Data File Cache Size : 33554432 Data Cache Size : 3145728 Aggregate Missing Values : No Perform two pass calc when [CALC ALL;] : Yes Create blocks on equation : No Currency DB Name : N/A Currency Conversion Type Member : N/A Currency Conversion Type : N/A Index Cache Size : 1048576 Index Page Size : 8192 Cache Memory Locking : Disabled Data Compression on Disk : Yes Data Compression Type : BitMap Compression Retrieval Buffer Size (in K) : 10 Retrieval Sort Buffer Size (in K) : 10 Isolation Level : Uncommitted Access Pre Image Access : Yes Time Out after : 20 sec. Number of blocks modified before internal commit : 3000 Number of rows to data load before internal commit : 0 Number of disk volume definitions : 0 I/O Access Mode (pending) : Buffered I/O Access Mode (in use) : Buffered Direct I/O Type (in use) : N/A
GETDBSTATS GetDbStats: Application name >appli001 Database name >appli001 -------Statistics of appli001:appli001 ------- Dimension Name Type Declared Size Actual Size =================================================================== CONSOLIDATION DENSE 13 13 PERIODES DENSE 18 17 ENTITES DENSE 97 96 INDICATEURS SPARSE 21339 21339 VENTILATION SPARSE 64 43 PHASES SPARSE 3 2 Number of dimensions : 6 Declared Block Size : 22698 Actual Block Size : 21216 Declared Maximum Blocks : 4097088 Actual Maximum Blocks : 1835154 Number of Non Missing Leaf Blocks : 403179 Number of Non Missing Non Leaf Blocks : 517208 Number of Total Blocks : 920387 Index Type : B+ TREE Average Block Density : 7.195937 Average Sparse Density : 50.15312 Block Compression Ratio : 0.08801508 Average Clustering Ratio : 0.9845904 Average Fragmentation Quotient : 20.58196
c SELECT Select: Enter application name >appli001 Enter database name >appli001
LISTUSERS ListUsers: -------User List------- ACPUCPA ACPUGPL AFP CANALR
GETUSERINFO veau GetUserInfo: User/Group Name: veau Description: EMail Identification: Locked out : No Change the password now : Yes Logged in: No Access Level: 0 Password Expiration in Days: 0 Last Successful Login: Never logged in Failed Login Attempts Since Then: 0 Login ID: 0
Copyright (c) 2010 Jean-Louis BICQUELET
This list of questions and answers was generated by makefaq.