1. Working with Oracle Smart View for Office
  2. Dimensions and Members
  3. Best Practices for Numeric Member Names

Best Practices for Numeric Member Names

Use the best practices noted in this topic when working with numeric member names in Oracle Smart View for Office.

Data source types: Oracle Essbase, Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

When working with numeric member names in Smart View:

  • 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.

The best practices noted above also need to be used when working with member names consisting of Boolean or date values.