1. User's Guide
  2. Dimensions and Members
  3. Numeric Member Names

Numeric Member Names

Oracle Smart View for Office has issues processing numeric member names when connected to Oracle Essbase.

Cloud data source types: Oracle Analytics Cloud - Essbase

On-premises data source types: Essbase

To workaround this:

  • Prefix numeric member names with an apostrophe (').

  • Before entering numeric member names, select the member cells or an entire column, then use Excel to set the format of the selected cells to "Text."

  • If you have already entered numeric member names, select the member cells or an entire column, use Excel to set the format of the selected cells to "Text,"then press F2 and Enter to trigger Excel to update the cell type.