Using API and Command-line Specifications
You can run PS2Essbase from the Create Cube page using Process Scheduler or the command line.
The following table lists the parameters that PS2Essbase uses when PS2Essbase runs from the command line.
Parameter |
Description |
---|---|
A, a |
Outline Name. |
R, r |
Run Control ID. |
I, i |
Process Instance ID number, such as I42, usually passed by Process Scheduler. |
CT, ct |
Database type. For example, -CTORACLE. |
CD, cd |
Database name. For example, -CDPT850RC1. |
CO, co |
Operator ID. For example, -COPTDMO. |
CP, cp |
Password. For example, -CPPTDMO. |
EC, ec |
Essbase Connection Name. |
OP, op |
Log files output destination. Note: When running PS2Essbase from the command line, in the –OP command line option, you must enclose the output destination patch in quotes. For example, –OP “c:\tmp\ps”. |
M, m |
Metadata action, such as -mC:
|
D, d |
Outline Restructure option:
|
L, l |
Logging level. For example, L31. |
X, x (optional) |
Dimension name for single dimension execution. |
Y, y (optional) |
PS Data Query name for single factory execution. |
Z, z |
Parameter used to load the aggregations on load option. Available options are:
|
For example, the parameters list passed using this command line:
ps2essbase.exe -CX -CTORACLE -CDPT850RC1 -COPTDMO
-CPPTDMO -I42 -OP "c:\tmp\ps" -REMPLOYMENT -aEG_DIVISION
-mC -dR-L15 -XGL_ACCOUNT -YQRY_MEASURES
Run Control ID = EMPLOYMENT
Outline = EG_DIVISION
Metadata Action = Create
Note: The log files will be deposited in the –OP location. For this example, the –OP location is “c:\tmp\ps”.
Restructure Option = Discard all data
These metadata and restructure options indicate that metadata will be fully recreated or created if it did not exist, and all previous data, if it existed, will be discarded.
Logging level includes Basic, Detail, Member, and Fact map logging; we specified L15, where 15 = 1 (Basic) + 2 (Detail) + 4 (Member) + 8 (Fact).
Single Dimension = GL_ACCOUNT
Single Data Query = QRY_MEASURES
Logging
You can pass the log level with the L option to the command line of psolap.exe; for example, L2 or L6, and so on.
The following table lists the log level and the data recorded in each log level.
Log Level |
What is recorded |
---|---|
1 |
Basic logging |
2 |
Detail logging |
4 |
Dimension member logging |
8 |
Fact map logging |
16 |
API logging |
When you run the process using Process Scheduler, the logging level is set on the Create Cube page. When you run the process from the command line, the logging level is set using the –L parameter. To calculate these logging settings, Cube Builder adds the options that you define. For example:
To see logs for Single Dimensions and Essbase API, enter
20
.20
is the sum of Dimension member logging + API logging =4 + 16 = 20
.To see all the logs that are available, enter
31
.31
is the sum of Basic logging + Detail logging + Dimension member logging + Fact map logging + API logging =1 + 2 + 4 + 8 + 16 = 31
.