 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
FAQ hyperion
Creation: 10 juin 2010
Mise à jour:
Version: 1.0
Author: Jean-Louis Bicquelet-Salaün
Location: http://jlbicquelet.free.fr
Copyright: (c) 2010 Jean-Louis BICQUELET-SALAÜN
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
Table of Contents
- 1. applications
- 2. hyperion
- 3. database
- 4. utilisateurs
- 5. tuning
1. applications
- 1.1. comment lister les applications ?
batman:::essprod[1]->listapp ListApp: Applications available: ABDPRO12 AEPRO004 AEPRO003 AFAPRO02 AFAPRO03
- 1.2. comment obtenir l'état d'une application?
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
- 1.3. comment obtenir les informations relatives à une application?
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
2. hyperion
- 2.1. comment se conencter ?
ESSCMD login serveur essbase mot_de_passe
- 2.2. quelles sont les commandes disponibles ?
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.
- 2.3. comment obtenir la version d'hyperion
getversion GetVersion: Hyperion Essbase OLAP Server - Version 6.5.1
- 2.4. où trouver un descriptif des commandes hyperion?
- La liste des commandes se trouve ici:
http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/esscmd/esscmd.htm
On peut à partir de la trouver la description de la commande:
http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/esscmd/select.htm
3. database
- 3.1. comment lister les db ?
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
- 3.2. comment obtenir les informations concernant une database
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- 3.3. comment obtenir l'état de la base ?
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
- 3.4. comment obtenir les statistiques sur la database?
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
- 3.5. omment selectionner une database ?
c SELECT Select: Enter application name >appli001 Enter database name >appli001
4. utilisateurs
- 4.1. comment obtenir la liste des utilisateurs?
LISTUSERS ListUsers: -------User List------- ACPUCPA ACPUGPL AFP CANALR
- 4.2. comment obtenir une liste sur les utilisateurs?
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
5. tuning
- 5.1. comment tuner une application hyperion?
- consulter la page getperfstats
Copyright (c) 2010 Jean-Louis BICQUELET
This list of questions and answers was generated by makefaq.