1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Functions
  3. Calculation Function Categories
  4. Miscellaneous Functions

Miscellaneous Functions

These calculation functions in Essbase did not fit into other categories:

To work with character strings, @CONCATENATE, @NAME, and @SUBSTRING are useful. To specify how formulas are calculated, use @CALCMODE to specify cell mode or block mode, and top-down versus bottom-up. @RETURN helps you exit a calculation using a custom message. @CREATEBLOCK populates cells with values or #MISSING.

  • @CALCMODE—This function enables you to specify whether a formula is calculated in cell mode or block mode and whether a formula is calculated bottom-up or top-down.

  • @CONCATENATE, @SUBSTRING, and @NAME—These functions enable manipulation of character strings.

  • @RETURN—This function enables termination of a calculation, with a custom error message.

  • @CREATEBLOCK—This function populates cells with values or #MISSING.