Common Function Error Codes

These are some common error codes displayed in functions.

#NO CONNECTION - You are not connected or logged on to a data source.

#Cube Not Selected - You are not connected at cube level.

#INVALID - Invalid metadata. Invalid cells that contain a value display the value as zero.

#LOCKED - The cell is locked.

#NO ACCESS - You do not have access to this cell.

#NO DATA - The cell contains NoData. You can select to display zeros instead of NoData. Cells use the Replacement text that you specify in the Options dialog box.

#INVALID INPUT - The HsSetValue data value is not valid, for example, a text string.

#READ ONLY - This is for the HsSetValue function only when the cell is Read-only.

#NO ROLE ACCESS - You do not have the Oracle Hyperion Financial Management LoadExcelData security role.

#NEEDS REFRESH - Data needs to be refreshed.

#INVALID DIMENSION - An invalid dimension is specified in the function.

#INVALID MEMBER - An invalid dimension member name is specified in the function.

#NAME - Excel does not recognize text in a formula. When you forward a worksheet that contains functions to a user who does not have Oracle Smart View for Office, they can view the same data as the functions on the worksheet. When the user edits or refreshes the function, it changes to #Name.