Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The ALLOCERRLOGFORMAT option determines the contents and the formatting of the error log that you specify with the ERRORLOG argument to the ALLOCATE command. You can specify a header for the error log with the ALLOCERRLOGHEADER option.
Syntax
ALLOCERRLOGFORMAT = text
Arguments
Characters that determine the contents and formatting of the error log that you specify with the VNF command. Table 7-3, "Characters for Specify the Contents of the Error Log for ALLOCATE" lists the characters that specify the contents of the error log.
Table 7-3 Characters for Specify the Contents of the Error Log for ALLOCATE
Character | Output Specified |
---|---|
b | The basis object being processed. |
c | The child node of the dimension being processed. |
d | The name of the dimension being processed. |
e | A description of the error encountered. |
n | The error code of the error encountered. |
p | The parent node of the dimension being processed. |
r | The name of the relation being allocated down. |
s | The source object being processed. |
t | The target object being processed. |
n | The basis value of the child cell receiving the allocation. |
y | The source value of the parent cell being allocated. |
z | The basis value of the parent cell being allocated. |
Notes
By placing an INTEGER value before the formatting character, you can specify the number of characters that the object occupies in the error log. The default value of ALLOCERRLOGFORMAT is the following.
'%8p %8y %8z %e (%n)'
You can specify escape sequences as formatting characters. For valid escape sequences, see "Escape Sequences".
The ERRORLOG command in an allocation specification specifies how many allocation error conditions to log and whether to continue or to stop the allocation when the specified maximum number of errors have been logged.
Examples