Options for Working with Empty Cells and Nonexistent Values |
Table: NA and Nonexistent Value Options lists the options that control how NA values are treated.
NA and Nonexistent Value Options
| Statement | Description |
|---|---|
| NASKIP
|
An option that controls whether NA values are considered as input to aggregation functions. |
| NASKIP2
|
An option that controls how NA values are treated in arithmetic operations with the + (plus) and - (minus) operators. |
| NASPELL
|
An option that controls the spelling that is used for NA values in output. |
| LIMITSTRICT
|
An option that determines how Oracle OLAP behaves when a list of values in a LIMIT command, a LIMIT function, or a QDR contains a nonexistent value. |
| RECURSIVE
|
An option that controls the ability of a formula or $NATRIGGER expression to call itself. |
| TRIGGERMAXDEPTH
|
An option that specifies the maximum number of $NATRIGGER property expressions that Oracle OLAP can execute simultaneously. |
| TRIGGERSTOREOK
|
An option that determines whether Oracle OLAP permanently replaces NA values in the cells of a variable with the value of the $NATRIGGER property expression that is set for the variable. |