@ISRANGENONEMPTY

The @ISRANGENONEMPTY calculation function for Essbase tests for data values in a range.

This function tests for the existence of data values, which can help you improve performance of complex dense processing. If this function returns true, values exist for the specified range. If it returns false, the range is empty.

Syntax

@ISRANGENONEMPTY(ZEROASDATA|ZEROASMISSG, mbrList)

Parameters

ZEROASDATA

Zero (0) values are treated as data.

ZEROASMISSG

Zero (0) values are treated as #MISSING.

mbrList

A valid member name, a comma-delimited list of member names, or a member set function that returns a list of members from the same dimension. If you use the range operator or a function, the order of mbrList is dictated by the database outline order.

Notes

The definition of “emptiness” depends on your use of the first parameter, which describes how zero (0) values are treated.

Example

The following examples use the Sample.Basic database.

Example 1

@ISRANGENONEMPTY(ZEROASDATA, Sales->Cola)

Because the intersection of Cola and Sales contains non-#MISSING values, the condition returns TRUE.

Example 2

//ESS_LOCALE English_UnitedStates.Latin1@Binary
FIX (Budget)
   Sales (IF(@ISRANGENONEMPTY(ZEROASMISSG, Jan:Mar))
      Sales = 500;
   ENDIF;);
ENDFIX

If there is any value except #MISSING in the range Jan:Mar in the database, the script returns TRUE, and all the Sales->Budget values In the database are changed to 500.