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.