A.4 Statements for Working with NA Values

Table A-4, "Statements for Working with NA Values" lists the OLAP DML statements that you use to work with NA values.

Table A-4 Statements for Working with NA Values

Statement	Description
CACHE	Within an aggregation specification, tells Oracle OLAP whether to cache or store `NA` values when a summary value calculates to `NA`
COALESCE	Returns the first non-NA expression in a list of expressions, or NA when all of the expressions evaluate to NA.
NAFILL	Returns the values of the source expression with any NA values appearing as the specified fill expression.
NVL	Replaces a NA value with a string.
NVL2	Returns one value when the value of a specified expression is not NA, or another value when the value of the specified expression is NA.